PgSQL 14 - Logical Rep - Single table multiple publications?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux