CODEWITHSUNDEEP
postgresqldatabase-replication
Kris
Kris

Reputation: 11

Postgres Streaming and Logical Replication

Currently we are using postgres streaming replication to sync/replicate databases on Primary and replica server. We are planning to use one of the application to sync data from our secondary or replica server to our data warehouse which needs logical replication to be enabled for tracking the changes and syncing the data from our replica server to data warehouse. Can we enable logical replication on top of streaming replication ? Is it possible or good practice to enable both on the same server or database ? If so, will there be any performance impact or what are the considerations or best practices to be followed?

Upvotes: 1

Views: 2197

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247865

There is no problem with using streaming (physical) replication and logical replication at the same time, but a physical standby server cannot be a logical primary. So you will have to use the same server as primary server for both physical and logical replication. But that shouldn't be a problem, since streaming replication primary and standby are physically identical anyway.

Upvotes: 2

Related Questions