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

There are no comments on this comment yet.