3 ms·
What do you guys use for large postgresql backups? Pgdump? Setting up replicas? Coming from ms sql, backups seem to be a pain in postgresql world, esp on a live
by polskibus 5y ago
What do you guys use for large postgresql backups? Pgdump? Setting up replicas? Coming from ms sql, backups seem to be a pain in postgresql world, esp on a live database that is receiving updates.
- stickfigure 5y agoOur hosted postgres instance (GCP) gets nightly backups automatically. Restoring to a new instance is a few buttonclicks in the UI. This is infrastructure level stuff that someone else should run.
- merb 5y agopgbackrest and/or wal-e/wal-g btw. it's important to make wal archive backups if you have a big database. https://www.postgresql.org/docs/14/continuous-archiving.html https://www.postgresql.org/docs/14/continuous-archiving.html so most of the time, both things are good. there is also: - Barman - pg_probackup (P.S: with archiving you can even have a "delayed" downstream cluster)
- __s 5y agoNot from Heap, but I use https://github.com/wal-g/wal-g https://github.com/wal-g/wal-g