News for hackers. Stuff that matters.
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.
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.

Re:Optimizing Postgres queries at scale by merb on Tuesday December 28, 2021 @03:13PM (#29717535)
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)

Re:Optimizing Postgres queries at scale by __s on Tuesday December 28, 2021 @03:14PM (#29717543)
Not from Heap, but I use https://github.com/wal-g/wal-g