Question 240491 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – 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.

Tags:

2

Answers


  1. 0

    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.

    Login or Signup to reply.
  2. 0

    Yes, you can definitely set up such a configuration with two servers, A and B, where server A is the publisher for table 1 and the subscriber for table 2, and server B is the publisher for table 2 and the subscriber for table 1. This is often referred to as a bidirectional replication setup.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search