PgSQL 14 - Logical Rep - Single table multiple publications?

Поиск
Список
Период
Сортировка
От Robert Blayzor
Тема PgSQL 14 - Logical Rep - Single table multiple publications?
Дата
Msg-id 3d5996ac-a181-21a5-62a0-1cd34e6b3f1a@inoc.net
обсуждение исходный текст
Ответы Re: PgSQL 14 - Logical Rep - Single table multiple publications?  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список 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 по дате отправления:

Предыдущее
От: Rick Otten
Дата:
Сообщение: Re: Postgresql 14 partitioning advice
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: PgSQL 14 - Logical Rep - Single table multiple publications?