[postgres-xl-general] PgLogical on Postgres-xl:: Minimistic configuration

Tomas Vondra tomas.vondra at 2ndquadrant.com
Thu Jan 25 13:42:50 PST 2018



On 01/13/2018 03:07 PM, Thomas Boussekey wrote:
> Hello all,
> 
> We are installing a proof-of-concept container environment on
> Postgres-XL to validate the feasability of a migration to this technical
> solution.
> 
> Our database, used by an OLTP retail application for point of sales
> management, must be a subscriber of a Pglogical replication to inherit
> of masterdata from a PostgreSQL master database.
> 
> According to PgLogical 2.1 release notes
> https://www.2ndquadrant.com/en/resources/pglogical/ , postgres-xl can
> subscribe to a PgLogical replication as subsriber.
> 
> According to slide 16 of the presentation regarding logical replication:
> https://www.slideshare.net/UmairShahid16/logical-replication-with-pglogical
> <https://www.slideshare.net/UmairShahid16/logical-replication-with-pglogical>
> , The "pglogical downstream" on the subscriber is connected to the
> "Parser/Executor" part of a single node database instance.
> On Postgres-XL, this part of the queries are managed on the coordinator
> nodes.
> 
> So my question is : "Where should we install Pglogical on a postgres-xl
> configuration? Is it sufficient to install pglogical extension on
> coordinator nodes only?"
> 

You only need to install it on one coordinator, which will act as the
pglogical downstream (and you should use pglogical.use_spi=true).


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



More information about the postgres-xl-general mailing list