Question regarding pglogical decoding

From: Baji Shaik <baji(dot)dba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question regarding pglogical decoding
Date: 2018-06-14 05:42:16
Message-ID: CAAYGEJb5_hNdtURAPveamKvGgcLZRFpPnAVeiSYhBcUOpN3WWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have a question regarding decoding of WALs in case of pglogical is used.

From my research, in native logical replication, decoding of WALs happens
for all changes of the database irrespective of tables in replication.
However, if pglogical is used, decoding happens ONLY for the tables which
are in replication? Or Slot streams all the changes and pglogical_output
plugin filters the changes based on replication sets?

I was going through pglogical_output
<https://github.com/2ndQuadrant/pglogical/blob/615a513c5707230d844316b2dc82739ae470ca3f/internals-doc/OUTPUT.md>
internal document, and under "Architecture and high level interaction"
section - "PostgreSQL then calls functions in this plugin to send it a
stream of transactions to decode and translate into network messages.". So,
it decodes transactions related to the tables in replication set? Or am I
misunderstanding it?

--
Regards,
Baji Shaik,
Senior Database Consultant | *OpenSCG*
*Blog: bajis-postgres.blogspot.in/ <http://bajis-postgres.blogspot.in/>*

Browse pgsql-general by date

  From Date Subject
Next Message Uri Braun 2018-06-14 12:04:32 Append only replication over intermittent links (with local only delete?)
Previous Message a 2018-06-14 05:34:31 Re: How to reference a composite type in schemas not "public"?