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();
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
