Subscriber to Get Only Some of The Tables From Publisher

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Subscriber to Get Only Some of The Tables From Publisher
Date: 2021-09-09 05:53:58
Message-ID: DB9PR07MB7180AA1E0D0C1DD8245C26E8CBD59@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a publisher with around 30 tables. I have two types of subscribers. Both types needs 25 "common" tables from the publisher plus 2-3 specific tables for each type of subscriber.

For maintenance and monitoring reasons it is better for me to have both subscribers point to the same publisher but "skip/ignore" 2-3 tables that are not needed for them. If this is not possible, I will be forced to create 2 publishers.

Any idea hot to ignore tables from publisher?
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-09-09 06:56:35 Re: Postgresql 11: terminating walsender process due to replication timeout
Previous Message Abhishek Bhola 2021-09-09 05:52:25 Postgresql 11: terminating walsender process due to replication timeout