*====> What is the procedure to make the failed master as working slave?* Check whether the following steps works for you... Assume the following is your use case., Master ----> Slave(Stand by..) Master replicating to slave. At time when master failed, the slave takes over as new master. Now your requirement to restart the failed master and reconfigure the same as standby for the new master. Stop the failed master. 1. Once the stand by taken over as master (once recovery.done and before any new data inserted...), copy file pg_control (available under data/global/) and the newly generated timeline history file available under archive folder (e-g., file like 00000002.history) 2. Remove all files under pg_xlog directory and in archive folder in the failed master . The above copied pg_control file, should be replaced in this failed master under data/global/). The above copied history should be copied in archive folder. Reconfigure the recovery.conf to point the new master Try starting the server..,(new standby) I hope it works ! - Senthil -- View this message in context: http://postgresql.1045698.n5.nabble.com/Queries-Regarding-Postgresql-Replication-tp4372554p4659365.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
