Re: Starting Postgre DB in read write mode

Hi,

Just set following and try to start your DB:

default_transaction_read_only=on;

in your postgresql.conf fie.

Regards,
Chander

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