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).
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).