Hacker News Reader

> The first consideration should be backups.

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

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

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

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

WAL-E/WAL-G are another option if you're looking for PITR.

Reply on news.ycombinator.com