4 ms·
Congratulations on the launch. Does PostgreSQL to PostgreSQL streaming using PeerDB have any benefit over just using Streaming Replication? Could this be used
by leononame 3y ago
Congratulations on the launch. Does PostgreSQL to PostgreSQL streaming using PeerDB have any benefit over just using Streaming Replication?
Could this be used as a sort of "live backup" of your data? (i.e. just making sure that data isn't lost if the server dies down completely, not thinking of HA)
Sorry if it's a bit of a stupid question, I realize it's not the main focus of PeerDB.
- saisrirampur 3y agoPostgres Streaming replication is very robust and has been in Postgres since multiple 10s of years. Logical replication/decoding (that PeerDB uses) is more recent - introduced in the last decade. However streaming replication is harder to manage/setup and a bit restrictive - most cloud providers don't give access to WAL, so you cannot use streaming replication to replicate data across cloud providers. Sure you can use PeerDB for backing up data - using CDC based replication or query based replication and both of these are pretty fast with PeerDB. You can have cold backups (store data to s3, blob etc) or hot backups (another postgres database). However note that the replication is async and there is some lag (few 10s of seconds) on the target data-store. So if you are expecting 0 data-loss, this won't be the right approach for backups/HA. With streaming replication, replication can be synchronous (synchronous_commit setting), which helps with 0 data-loss.