PG 9.6 managed fail over of master, how do i manage a pg_logical subscriber

From: Reid Thompson <Reid(dot)Thompson(at)omnicell(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Reid Thompson <Reid(dot)Thompson(at)omnicell(dot)com>
Subject: PG 9.6 managed fail over of master, how do i manage a pg_logical subscriber
Date: 2019-02-19 20:51:16
Message-ID: 82ee44620ca6fec107d4d1c1385280dc40806d13.camel@omnicell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have the following configuration.

pg9.6_master --> streaming replica pg9.6_standy
--> pg_logical replication of several schemas to pg9.6_logical

We plan to perform a managed fail over of pg9.6_master to pg9.6_standy.
As part of the fail over, the virtual IP address and hostname of
pg9.6_master will be migrated to pg9.6_standy.
I'm looking for guidance on how to keep the pg_logical replication going
to pg9.6_logical from the newly promoted 'master'.

If I shutdown pg9.6_logical prior to the fail over, and start it back up
after the failover, it should come up 'believing' that pg9.6_standby is
pg9.6_master, will it 'just work'? or is there a process that I need to
follow have pg9.6_logical succesfully replicate from the newly promoted
host?

thanks,
reid

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-02-19 21:14:37 Re: Partial index on JSON column
Previous Message Samuel Williams 2019-02-19 20:41:40 Partial index on JSON column