postgresqlpostgresql-12

Can a postgres server be publisher for some tables and subscribers for others?


I am having 2 servers, server (A,B). Can server A be publisher for table 1 and subscriber for table 2. And server B be publisher for table 2 and subscriber for table 1.

What i reached so far, server A is publisher for table 1 and server B subscribed to it successfully.


Solution

  • Yes, there is no problem with a setup like that, as long as there are no don't try to replicate the same table in both directions.