Starting Postgre DB in read write mode
Starting Postgre DB in read write mode
Hi
Due to some upgrade activity, I break the master slave DB sync on two site.
Now I want to start the DB of secondary site [Slave DB ] in read write mode so that I can update the DB manually. How can I do that as after break slave DB is working in read only mode.
Regards,
Ashwani Kumar
Ericsson India Global Services Private Limited
Mobile : +91 9999771339
Skype ID : Ashwani.k.07
www.ericsson.com
Re: Starting Postgre DB in read write mode
Hi
Due to some upgrade activity, I break the master slave DB sync on two site.
Now I want to start the DB of secondary site [Slave DB ] in read write mode so that I can update the DB manually. How can I do that as after break slave DB is working in read only mode.
Regards,
Ashwani Kumar
Ericsson India Global Services Private LimitedMobile : +91 9999771339
Skype ID : Ashwani.k.07
www.ericsson.com
Re: Starting Postgre DB in read write mode
To open slave server in read/write mode you can use below command.
pg_ctl -D <your slave data directory> promote
Hope this helps..
Hi
Due to some upgrade activity, I break the master slave DB sync on two site.
Now I want to start the DB of secondary site [Slave DB ] in read write mode so that I can update the DB manually. How can I do that as after break slave DB is working in read only mode.
Regards,
Ashwani Kumar
Ericsson India Global Services Private LimitedMobile : +91 9999771339
Skype ID : Ashwani.k.07
www.ericsson.com