Streaming replication failover process - Pgsql 9.2

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Streaming replication failover process - Pgsql 9.2
Date: 2016-07-10 21:19:14
Message-ID: CAJNY3itutsBoh3Wyf7pApRD-WZ82TPr2n2Qp=FBiCuB1WkUL+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

There will be a network maintenance at the company where my servers are...

I've got one master and one slave server, running PostgreSQL 9.2.

As the network will be down, the internet won't be working as well as the
intranet. Both servers won't be able to communicate each other. Not by
streaming replication and wal_files too.

That should take at most 10 minutes.

1. When the connection comes back, will the master and slave work as
expected? The streaming replication should be ok?

2. As the master will be down, I don't wanna slave turns into a master by
Failover. The trigger_file line on recovery.conf on the slave server is
commented, so should be ok here right? The slave will be still a slave once
master is down....

Thanks!
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-07-10 21:31:01 Re: Streaming replication failover process - Pgsql 9.2
Previous Message Adrian Klaver 2016-07-10 17:07:45 Re: error when upgrading 9.4 to 9.5 manually