3 ms·

Is 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 cen

• billhathaway 9y ago
  Would 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 ago
  Yeah, just have a read replica. Can promote it to master later