News for hackers. Stuff that matters.
Re:Fully managed PostgreSQL databases by matthewaveryusa on Thursday February 14, 2019 @12:30PM (#19163790)
I'll bet it's async replication with streaming. Anything else costs too much in complexity and performance. Of course the cost of such a setup is a small window where data loss is possible -- but if you're ok with this service you're already ok with data loss because the daily backups lose any add+delete operations you do in a day (unless you have triggers that copy the deleted data in a shadow table)
Re:Fully managed PostgreSQL databases by manigandham on Friday February 15, 2019 @12:55AM (#19168778)
They have point-in-time restore which means they're archiving the WAL logs continuously. You don't lose an entire day's worth of changes.