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(dot)Maddali(at)nuance(dot)com> wrote:

> Please read the tutorials
>
>
>
> https://cloud.google.com/community/tutorials/setting-
> up-postgres-hot-standby
>
>
>
>
>
> *From:* pgus-general-owner(at)postgresql(dot)org [mailto:pgus-general-owner@
> postgresql.org] *On Behalf Of *Prashanth Reddy
> *Sent:* Tuesday, July 18, 2017 7:58 AM
> *To:* pgsql-admin(at)postgresql(dot)org; pgus-general(at)postgresql(dot)org;
> pgsql-sql(at)postgresql(dot)org; pgsql-in-general(at)postgresql(dot)org;
> pgsql-novice(at)postgresql(dot)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(at)gmail(dot)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
>
>
>