Re: Test failover for PosgreSql 9.2 - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Test failover for PosgreSql 9.2
Date
Msg-id 5605FD5E.9000802@natserv.net
Whole thread Raw
In response to Test failover for PosgreSql 9.2  (yuryu <yudis@illumina.com>)
List pgsql-general
On 09/25/2015 11:20 AM, yuryu wrote:
> According to manual I have to kill completely Master and "touch" a trigger
> to make Slave new Master.

You don't have to do anything in the master. If you have configured the
slave to check for a file, then it will become Read Write when that file
is created.

You can also do
pg_ctlcluster #.# main promote

Where #.# is version like
pg_ctlcluster 9.3 main promote

In the slave you can run this to check if it is in read only
(replicating) or read write
select pg_is_in_recovery();


pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Listen/notify, equivalents on other DBs
Next
From: Thomas Kellerer
Date:
Subject: Re: Listen/notify, equivalents on other DBs