Re: Starting Postgre DB in read write mode

[Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>]

Hi Ashwani Kumar ,

To open slave server in read/write mode you can  use below command.

pg_ctl -D <your slave data directory>  promote

Hope this helps..

​

---

On Thu, Jan 18, 2018 at 3:01 PM, Ashwani Kumar B <ashwani.b.kumar@xxxxxxxxxxxx> wrote:

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

ashwani.b.kumar@xxxxxxxxxxxx

Mobile : +91 9999771339

Skype ID : Ashwani.k.07
www.ericsson.com