4 ms·
Hey Dan, nice to hear from you! > our prod base backups take 36 hours to restore, so if the recovery speed improvements are as advertised, that's a big win. Y
by ozgune 9y ago
Hey Dan, nice to hear from you!
> our prod base backups take 36 hours to restore, so if the recovery speed improvements are as advertised, that's a big win.
Yes, if you attach 16TB of storage to each instance, your back-up restores may take a while. :))
- paulsutter 9y agoIs it possible to run a continuous restore in parallel with normal operation so that there's a warm standby (almost) ready to go? Especially in another data center?
- billhathaway 9y agoWould standard postgres streaming replication do what you are looking for? https://wiki.postgresql.org/wiki/Streaming_Replication https://wiki.postgresql.org/wiki/Streaming_Replication We use a combination of streaming replication and wal-e backups. A separate machine performs multiple restores per hour and verifies restores work ok and that the data is recent.
- bpicolo 9y agoYeah, just have a read replica. Can promote it to master later