Postgres Pro
Downloads
Home   >   mailing lists

pglogical setup in cascade replication architecture - Mailing list pgsql-hackers

From Perumal Raj
Subject pglogical setup in cascade replication architecture
Date
Msg-id CALvqh4owcqsfH_CBrtfi+gkt5BqLycwJX8zH8LXdLnQs-vdDcg@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view
Hi Team,

I have cascade level streaming replication & WAL Apply setup .

Primary -> Secondary 1 -> Secondary 2,Secondary 3
WAL Archive -> Secondary 4

I am expanding setup by adding another Replica from Primary -> Secondary 5 for logical streaming.

Do I need to install and configure pglogical on all the cluster nodes ?

Or just need between Primary and Secondary 5 ?

What will happen if I miss pglogical configuration in any one of the Secondary node?

Version : >=  9.6

Please share your experience.

Thanks








pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Privileges on PUBLICATION
Next
From: Thomas Munro
Date:
Subject: Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?