News for hackers. Stuff that matters.

A comment on Fully managed PostgreSQL databases. Parent comment

Re:Fully managed PostgreSQL databases by keypusher on Thursday February 14, 2019 @04:12PM (#19166075)
How is the WAL stored? If there is a problem with the storage, networking, or DC, you will not be able to get the WAL in order to bring up the DB in a new region. Also, the process of replaying WAL since last backup can take a very long time for a high traffic DB, during which time it is going to be completely unavailable.
[ Parent | on HN ]
Re:Fully managed PostgreSQL databases by kamaln7 on Friday February 15, 2019 @10:15AM (#19171512)
The WAL and all backups are stored offsite and are completely handled on our end.

Re: availability, that’s right if you only have a primary node and no standby ones. Like manigandham said, there won’t be any downtime if you have a standby node.

[ Parent | on HN ]
Re:Fully managed PostgreSQL databases by manigandham on Friday February 15, 2019 @12:58AM (#19168788)
That's what a standby server is for, so that it's up to date without replaying the WAL. Nothing unique to DigitalOcean about that.
[ Parent | on HN ]