Re:PostgreSQL DBaaS vendor comparison and calculator
by lincolnq on Sunday March 31, 2019 @09:51AM
(#19535572)
Do any of these services provide point-in-time backup recovery? It is very easy to implement with WAL archiving on my own deployment but I haven’t found any hosted services who do it.
[ Parent
| on HN ]
Re:PostgreSQL DBaaS vendor comparison and calculator
by TurningCanadian on Sunday March 31, 2019 @02:33PM
(#19537315)
Google cloud has MySQL PITR
https://cloud.google.com/sql/docs/mysql/backup-recovery/rest...
Oddly seems missing from their PostgreSQL offering though, which is also several versions behind.
https://issuetracker.google.com/issues/71565188#comment73 mentions Aiven, which looks good to me..
Re:PostgreSQL DBaaS vendor comparison and calculator
by theptip on Sunday March 31, 2019 @02:52PM
(#19537472)
I've been staying off Google's postgres offering for this reason; am I missing something about Postgres replication methods, or is this a massive hole in their offering?
Re:PostgreSQL DBaaS vendor comparison and calculator
by cdmckay on Sunday March 31, 2019 @10:38AM
(#19535796)
I believe RDS supports this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
Re:PostgreSQL DBaaS vendor comparison and calculator
by adrianmsmith on Sunday March 31, 2019 @01:47PM
(#19536979)
Can confirm that RDS does and I've used it and it works.
Re:PostgreSQL DBaaS vendor comparison and calculator
by tda on Sunday March 31, 2019 @04:48PM
(#19538280)
Azure does, 35 days PITR andI beleive you only pay for the storage costs. Recovery is only on a database server level (not an individual database), and works by creating a new instance (the original instance is left as is) that is set to the state at the desired point in time.