3 ms·
> 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://www.pgbarman.org
by throw0101a 6y ago
> 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://www.pgbarman.org/
* https://github.com/2ndquadrant-it/barman https://github.com/2ndquadrant-it/barman
No sense re-inventing the wheel if it can be avoided.
- fabian2k 6y agoWAL-E/WAL-G are another option if you're looking for PITR.
- zomgwat 6y agoI'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).