agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedSteps to place standby database in read write
6+ messages / 3 participants
[nested] [flat]
* Steps to place standby database in read write
@ 2017-07-18 01:27 Prashanth Reddy <prash4783@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Prashanth Reddy @ 2017-07-18 01:27 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Steps to place standby database in read write
@ 2017-07-18 14:58 Prashanth Reddy <prash4783@gmail.com>
parent: Prashanth Reddy <prash4783@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Prashanth Reddy @ 2017-07-18 14:58 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgus-general@postgresql.org; pgsql-sql; pgsql-in-general@postgresql.org; pgsql-novice@postgresql.org
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write
@ 2017-07-18 15:01 Maddali, Srinivas <Srinivas.Maddali@nuance.com>
parent: Prashanth Reddy <prash4783@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Maddali, Srinivas @ 2017-07-18 15:01 UTC (permalink / raw)
To: Prashanth Reddy <prash4783@gmail.com>; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgus-general@postgresql.org <pgus-general@postgresql.org>; pgsql-sql; pgsql-in-general@postgresql.org <pgsql-in-general@postgresql.org>; pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
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<mailto: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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Steps to place standby database in read write
@ 2017-07-18 15:02 Ashish Tiwari <tashish786@gmail.com>
parent: Prashanth Reddy <prash4783@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Ashish Tiwari @ 2017-07-18 15:02 UTC (permalink / raw)
To: Prashanth Reddy <prash4783@gmail.com>; +Cc: pgsql-admin <pgsql-admin@postgresql.org>; pgsql-novice@postgresql.org; pgus-general@postgresql.org; pgsql-in-general@postgresql.org; pgsql-sql
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
>>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write
@ 2017-07-18 15:35 Prashanth Reddy <prash4783@gmail.com>
parent: Maddali, Srinivas <Srinivas.Maddali@nuance.com>
0 siblings, 1 reply; 6+ messages in thread
From: Prashanth Reddy @ 2017-07-18 15:35 UTC (permalink / raw)
To: Maddali, Srinivas <Srinivas.Maddali@nuance.com>; Ashish Tiwari <tashish786@gmail.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgus-general@postgresql.org <pgus-general@postgresql.org>; pgsql-sql; pgsql-in-general@postgresql.org <pgsql-in-general@postgresql.org>; pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
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
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write
@ 2017-07-18 15:59 Maddali, Srinivas <Srinivas.Maddali@nuance.com>
parent: Prashanth Reddy <prash4783@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Maddali, Srinivas @ 2017-07-18 15:59 UTC (permalink / raw)
To: Prashanth Reddy <prash4783@gmail.com>; Ashish Tiwari <tashish786@gmail.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgus-general@postgresql.org <pgus-general@postgresql.org>; pgsql-sql; pgsql-in-general@postgresql.org <pgsql-in-general@postgresql.org>; pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
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<mailto:Srinivas.Maddali@nuance.com>> wrote:
Please read the tutorials
https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby<https://urldefense.p...;
From: pgus-general-owner@postgresql.org<mailto:pgus-general-owner@postgresql.org> [mailto: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<mailto:pgsql-admin@postgresql.org>; pgus-general@postgresql.org<mailto:pgus-general@postgresql.org>; pgsql-sql@postgresql.org<mailto:pgsql-sql@postgresql.org>; pgsql-in-general@postgresql.org<mailto:pgsql-in-general@postgresql.org>; pgsql-novice@postgresql.org<mailto: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<mailto: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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2017-07-18 15:59 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-18 01:27 Steps to place standby database in read write Prashanth Reddy <prash4783@gmail.com>
2017-07-18 14:58 ` Prashanth Reddy <prash4783@gmail.com>
2017-07-18 15:01 ` Maddali, Srinivas <Srinivas.Maddali@nuance.com>
2017-07-18 15:35 ` Prashanth Reddy <prash4783@gmail.com>
2017-07-18 15:59 ` Maddali, Srinivas <Srinivas.Maddali@nuance.com>
2017-07-18 15:02 ` Ashish Tiwari <tashish786@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox