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/>*
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"? |