Starting Postgre DB in read write mode

Поиск
Список
Период
Сортировка
Искать

Starting Postgre DB in read write mode

От:
Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
Дата:
Вложения:

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@ericsson.com

Mobile : +91 9999771339

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

 

Re: Starting Postgre DB in read write mode

От:
Chander Jamwal <silvi.jamwal@gmail.com>
Дата:
Вложения:
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,

Ashwani Kumar
Ericsson India Global Services Private Limited


ashwani.b.kumar@ericsson.com

Mobile : +91 9999771339

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

 


Re: Starting Postgre DB in read write mode

От:
Shreeyansh Dba <shreeyansh2014@gmail.com>
Дата:
Вложения:
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@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,

Ashwani Kumar
Ericsson India Global Services Private Limited


ashwani.b.kumar@ericsson.com

Mobile : +91 9999771339

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

 





FAQ