3 ms·
> If you think backup tools are a minus for PG, I guess you've never used barman You are right, I've never used barman. But I have streaming replication config
by dgregd 10y ago
> If you think backup tools are a minus for PG, I guess you've never used barman
You are right, I've never used barman. But I have streaming replication configured manually. Generally I am quite happy with PG backup tools.
However this discussion made me to think about pg_dump deficiencies. WAL backup is for whole db cluster. But how do I incrementally update one db? E.g. one prod db to my dev environment.
- SEJeff 10y agoIndeed, that is something that WAL files don't work for. There aren't a lot of great answers for that. I generally will restore a point in time snapshot somewhere and then dump out that entire db to restore via sql or whatnot.