Re: Starting Postgre DB in read write mode

[Chander Jamwal <silvi.jamwal@xxxxxxxxx>]

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