Обсуждение: [ADMIN] Steps to place standby database in read write

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

[ADMIN] Steps to place standby database in read write

От
Prashanth Reddy
Дата:
Hi,
Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.
--
Sent from Gmail Mobile

Re: [ADMIN] Steps to place standby database in read write

От
Prashanth Reddy
Дата:
Help anyone!?

Regards,
Prashanth
9989819107

On Mon, Jul 17, 2017 at 8:27 PM, Prashanth Reddy <prash4783@gmail.com> wrote:
Hi,
Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.
--
Sent from Gmail Mobile

[ADMIN] Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database inread write

От
"Maddali, Srinivas"
Дата:

Please read the tutorials

 

https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby

 

 

From: pgus-general-owner@postgresql.org [mailto:pgus-general-owner@postgresql.org] On Behalf Of Prashanth Reddy
Sent: Tuesday, July 18, 2017 7:58 AM
To: pgsql-admin@postgresql.org; pgus-general@postgresql.org; pgsql-sql@postgresql.org; pgsql-in-general@postgresql.org; pgsql-novice@postgresql.org
Subject: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write

 

Help anyone!?


Regards,

Prashanth
9989819107

 

On Mon, Jul 17, 2017 at 8:27 PM, Prashanth Reddy <prash4783@gmail.com> wrote:

Hi,

Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.

--

Sent from Gmail Mobile

 

Re: [ADMIN] Steps to place standby database in read write

От
Ashish Tiwari
Дата:
Hi Prashant,
I will forward you document in sometime.

Thanks.

On Jul 18, 2017 8:28 PM, "Prashanth Reddy" <prash4783@gmail.com> wrote:
Help anyone!?

Regards,
Prashanth
9989819107

On Mon, Jul 17, 2017 at 8:27 PM, Prashanth Reddy <prash4783@gmail.com> wrote:
Hi,
Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.
--
Sent from Gmail Mobile

[ADMIN] Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database inread write

От
Prashanth Reddy
Дата:
Hi Srinivas,
Thanks for reaching out to me. 
We are not in the process of setting up the hot-standby.
we are in the process of testing the DR databases, so we want to place the standby database out of sync from PROD by disabling the replication on DR site , place the DR database in read-write mode for testing purpose, once the application testing is done, we would like to place the DR database back in sync with PROD.


NOTE: For Hot-standby we are using rsync method.

another question on postgres database logs: Is there any other location for the log files apart from "/var/log/postgresql" location?



Regards,
Prashanth
9989819107

On Tue, Jul 18, 2017 at 10:01 AM, Maddali, Srinivas <Srinivas.Maddali@nuance.com> wrote:

Please read the tutorials

 

https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby

 

 

From: pgus-general-owner@postgresql.org [mailto:pgus-general-owner@postgresql.org] On Behalf Of Prashanth Reddy
Sent: Tuesday, July 18, 2017 7:58 AM
To: pgsql-admin@postgresql.org; pgus-general@postgresql.org; pgsql-sql@postgresql.org; pgsql-in-general@postgresql.org; pgsql-novice@postgresql.org
Subject: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write

 

Help anyone!?


Regards,

Prashanth
9989819107

 

On Mon, Jul 17, 2017 at 8:27 PM, Prashanth Reddy <prash4783@gmail.com> wrote:

Hi,

Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.

--

Sent from Gmail Mobile

 


[ADMIN] Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database inread write

От
"Maddali, Srinivas"
Дата:

Then after the maintenance, recv or fsync makes transaction commit wait for XLOG to be received or fsync-ed by the stand by database.

 

 

Further read

 

https://wiki.postgresql.org/wiki/Streaming_Replication#Synchronization_capability

 

 

 

From: Prashanth Reddy [mailto:prash4783@gmail.com]
Sent: Tuesday, July 18, 2017 8:36 AM
To: Maddali, Srinivas <Srinivas.Maddali@nuance.com>; Ashish Tiwari <tashish786@gmail.com>
Cc: pgsql-admin@postgresql.org; pgus-general@postgresql.org; pgsql-sql@postgresql.org; pgsql-in-general@postgresql.org; pgsql-novice@postgresql.org
Subject: Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write

 

Hi Srinivas,
Thanks for reaching out to me. 
We are not in the process of setting up the hot-standby.
we are in the process of testing the DR databases, so we want to place the standby database out of sync from PROD by disabling the replication on DR site , place the DR database in read-write mode for testing purpose, once the application testing is done, we would like to place the DR database back in sync with PROD.


NOTE: For Hot-standby we are using rsync method.

another question on postgres database logs: Is there any other location for the log files apart from "/var/log/postgresql" location?


Regards,

Prashanth
9989819107

 

On Tue, Jul 18, 2017 at 10:01 AM, Maddali, Srinivas <Srinivas.Maddali@nuance.com> wrote:

Please read the tutorials

 

https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby

 

 

From: pgus-general-owner@postgresql.org [mailto:pgus-general-owner@postgresql.org] On Behalf Of Prashanth Reddy
Sent: Tuesday, July 18, 2017 7:58 AM
To: pgsql-admin@postgresql.org; pgus-general@postgresql.org; pgsql-sql@postgresql.org; pgsql-in-general@postgresql.org; pgsql-novice@postgresql.org
Subject: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write

 

Help anyone!?


Regards,

Prashanth
9989819107

 

On Mon, Jul 17, 2017 at 8:27 PM, Prashanth Reddy <prash4783@gmail.com> wrote:

Hi,

Can you please provide me the steps as how to stop the replication and open the standby database for read write and put the standby database back in sync with production.

--

Sent from Gmail Mobile