undefined | Better HN

0 pointsdgregd9y ago0 comments

> 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.

0 comments

1 comments · 1 top-level

SEJeff9y ago

Indeed, 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.

j / k navigate · click thread line to collapse