News for hackers. Stuff that matters.
Re:Mastering PostgreSQL Administration [pdf] by throw0101a on Sunday September 27, 2020 @01:06PM (#24608133)
> The first consideration should be backups.

Useful to look at barman and see if it can meet one's needs:

* https://www.pgbarman.org/

* https://github.com/2ndquadrant-it/barman

No sense re-inventing the wheel if it can be avoided.

Re:Mastering PostgreSQL Administration [pdf] by zomgwat on Sunday September 27, 2020 @01:56PM (#24608632)
I've been very satisfied with Barman. I considered a variety of backup options including replication. Barman is a good alternative to replication if you can tolerate a small mount of downtime while you restore. For us, it takes less than 15 minutes to provision a new VM and restore from Barman. I’m ok with that downtime because it simplifies operations by eliminating the need to operate a secondary database sever and manage replication.

Also, Barman offers point-in time recovery (PITR).

Lastly, we do a nightly logical dump which gets uploaded to a bucket (located at another cloud service).

Re:Mastering PostgreSQL Administration [pdf] by fabian2k on Sunday September 27, 2020 @01:40PM (#24608463)
WAL-E/WAL-G are another option if you're looking for PITR.