Re:Optimizing Postgres queries at scale
by polskibus on Tuesday December 28, 2021 @02:00PM
(#29716750)
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.
[ Parent
| on HN ]
Re:Optimizing Postgres queries at scale
by stickfigure on Tuesday December 28, 2021 @02:04PM
(#29716784)
Our 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.
pgbackrest
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
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)
Not from Heap, but I use https://github.com/wal-g/wal-g