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();