On Fri, Oct 21, 2016 at 10:10 PM, Dasitha Karunajeewa <dasitha@xxxxxxxxxxxxxxx> wrote: > What I want to know is how to switch them back to the normal status. That > means pgmaster need to be the Master server which acept the writed and > pgslave that accepts only reads along with the replication. If your promoted standby got ahead of the former master, you could use the promoted standby as a new master, and replug the former master as a standby. The latter step can be done by either running pg_rewind on the former masfer or taking a new base backup from the promoted standby and use that to set up a new standby. pg_rewind will be successful to run only if the master has kept WAL segments from the last checkpoint record where WAL forked when standby has been promoted. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
