PgSQL 14 - Logical Rep - Single table multiple publications? - Mailing list pgsql-performance

From Robert Blayzor
Subject PgSQL 14 - Logical Rep - Single table multiple publications?
Date
Msg-id 3d5996ac-a181-21a5-62a0-1cd34e6b3f1a@inoc.net
Whole thread Raw
Responses Re: PgSQL 14 - Logical Rep - Single table multiple publications?  (Rory Campbell-Lange <rory@campbell-lange.net>)
List 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/



pgsql-performance by date:

Previous
From: Rick Otten
Date:
Subject: Re: Postgresql 14 partitioning advice
Next
From: Rory Campbell-Lange
Date:
Subject: Re: PgSQL 14 - Logical Rep - Single table multiple publications?