Re: Starting Postgre DB in read write mode

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..

​
---
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com/>

On Thu, Jan 18, 2018 at 3:01 PM, Ashwani Kumar B <
ashwani(dot)b(dot)kumar(at)ericsson(dot)com> 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,*
>
> [image: Description: Description: Description: Description: line]
>
> *Ashwani Kumar*
> Ericsson India Global Services Private Limited
>
> [image: Description: Description:
> http://www.yourconferencecentre.com/ericsson/Brand/images/other/other_logo.gif]
> ashwani(dot)b(dot)kumar(at)ericsson(dot)com
>
> Mobile : +91 9999771339
>
> Skype ID : Ashwani.k.07
> www.ericsson.com
>
>
>