Postgres Pro
Downloads
Home   >   mailing lists

Re: Starting Postgre DB in read write mode - Mailing list pgsql-admin

From Chander Jamwal
Subject Re: Starting Postgre DB in read write mode
Date
Msg-id CABbzzyiTyFnGNR57iY0wPce6EMfppyWWuE2ZahtFPy_Sp8djsg@mail.gmail.com
Whole thread Raw
In response to Starting Postgre DB in read write mode  (Ashwani Kumar B <ashwani.b.kumar@ericsson.com>)
List pgsql-admin
Tree view
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@ericsson.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,

Description: Description: Description: Description: line

Ashwani Kumar
Ericsson India Global Services Private Limited

Description: Description: http://www.yourconferencecentre.com/ericsson/Brand/images/other/other_logo.gif
ashwani.b.kumar@ericsson.com

Mobile : +91 9999771339

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

 


Attachment

pgsql-admin by date:

Previous
From: Ashwani Kumar B
Date:
Subject: Starting Postgre DB in read write mode
Next
From: Shreeyansh Dba
Date:
Subject: Re: Starting Postgre DB in read write mode