PgSQL 14 - Logical Rep - Single table multiple publications?

From: Robert Blayzor <rblayzor(dot)bulk(at)inoc(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: PgSQL 14 - Logical Rep - Single table multiple publications?
Date: 2022-08-02 13:57:50
Message-ID: 3d5996ac-a181-21a5-62a0-1cd34e6b3f1a@inoc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Using logical replication is it possible to have a single table
subscriber connect to multiple publishers of the same table ? This
would be for INSERT's only.

Think multiple DB publishers just inserting records (audit transaction
logs)....

Is it possible to have a single subscriber table contact multiple
publishers and just insert all of the data into a single table on the
subscriber? ie: merge type replication. There are no primary/FK
constraints, etc. The records are just time based audit log type data...

--
inoc.net!rblayzor
XMPP: rblayzor.AT.inoc.net
PGP: https://pgp.inoc.net/rblayzor/

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rory Campbell-Lange 2022-08-02 14:57:39 Re: PgSQL 14 - Logical Rep - Single table multiple publications?
Previous Message Rick Otten 2022-08-02 12:54:46 Re: Postgresql 14 partitioning advice