Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgus-general-owner+M298=pgus+2Dgeneral=arkaria.postgresql.org@postgresql.org>)
	id 1dXTx4-00076n-WF
	for pgus-general@arkaria.postgresql.org; Tue, 18 Jul 2017 14:58:19 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgus-general-owner+M298=pgus+2Dgeneral=arkaria.postgresql.org@postgresql.org>)
	id 1dXTx3-0000xj-VJ
	for pgus-general@arkaria.postgresql.org; Tue, 18 Jul 2017 14:58:18 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <prash4783@gmail.com>)
	id 1dXTx3-0000xC-DO; Tue, 18 Jul 2017 14:58:17 +0000
Received: from mail-ua0-x231.google.com ([2607:f8b0:400c:c08::231])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <prash4783@gmail.com>)
	id 1dXTx0-0003ty-UT; Tue, 18 Jul 2017 14:58:16 +0000
Received: by mail-ua0-x231.google.com with SMTP id y47so11302921uag.0;
        Tue, 18 Jul 2017 07:58:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to;
        bh=q2sgWtzpEFEQw4NyIsp3rhzGxKaXab+hFoSFHaAzqE8=;
        b=iNxP337A1AyPUo+WqCeGvkraCOyv/+pehy2vjq1pSRTctU8s5oKwQxtutexJ/U6kBI
         Ao54NqYW8bXBH4hUiU/Vn8ssJt4W+T6Qi/oygoU+exTIjBiD7RLenVI4X8zbkphi8S4+
         H0GxRfhww661Sg/21p2ACT1Tq7wJi/do5m8I0ycP31cEuXK5OijBOCxHYS1QXqJhSgDe
         acxIKNdMyw6BoCHnJlf9ZNlPCI4jwcl+ig8GTWgqK8uU+cB0CeQCX/BQ3veVRXGy8mMh
         0wKelBFums1ukW5MhVfXbaQfYI4PjKFU4pBZGdvgXqUprBhQyq69kOAW2LKbx1SamSp+
         Q4Dw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to;
        bh=q2sgWtzpEFEQw4NyIsp3rhzGxKaXab+hFoSFHaAzqE8=;
        b=pxtXTJ8unfrjFPEcE51l8UspAdFIqz4QDRwXOqQZm8A2j4lMt9dnLGuXg1EPXHdqHd
         cnnl7lac+MUfioDAbsVMGN58RVQvGGDtjUWMvOL9whWi3hdXGzjIapTudzPzqmet8li6
         ekqZRrk7+ZtPaY9ofMv84NsfY+++KwgOiSzRmfD0gmrFhETJpcr9djO9O1qykLTldwNi
         1eUcZwHbtBTGW+1NwEKrXBbwt15G4Kt5b8hGPMk8PhVZKep80atrw1qwiDqKnhnEBdq1
         O4NyDsJ0xZKmJxd43G9Hnei1G3lC6qzX75W4HXftZR0e4rwAKLRZc+Ac+F95qZDnJWeb
         eD0Q==
X-Gm-Message-State: AIVw113bQ7WsDLLkC+/MEl5/YWapblLJnOi6zcfnjxdT0szZ9HcDmngw
	i+D8lZkKV5iZcTwozIJ1phgXnzF48eF6
X-Received: by 10.31.102.133 with SMTP id a127mr1100549vkc.107.1500389893313;
 Tue, 18 Jul 2017 07:58:13 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.103.10.134 with HTTP; Tue, 18 Jul 2017 07:58:12 -0700 (PDT)
In-Reply-To: 
 <CANN5QLbdhn9e66riKBWbONSL=oFYUdF195pJHifoNkSUhQWu4Q@mail.gmail.com>
References: 
 <CANN5QLbdhn9e66riKBWbONSL=oFYUdF195pJHifoNkSUhQWu4Q@mail.gmail.com>
From: Prashanth Reddy <prash4783@gmail.com>
Date: Tue, 18 Jul 2017 09:58:12 -0500
Message-ID: 
 <CANN5QLYRUtFTdV3B3BZ+JCUm98MnvTvcCiftyZx3RaAA_=Nexg@mail.gmail.com>
Subject: Re: Steps to place standby database in read write
To: pgsql-admin@postgresql.org, pgus-general@postgresql.org,
	pgsql-sql@postgresql.org, pgsql-in-general@postgresql.org,
	pgsql-novice@postgresql.org
Content-Type: multipart/alternative; boundary="94eb2c0930929d9921055498be4b"
List-Archive: <http://archives.postgresql.org/pgus-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgus-general.postgresql.org>
List-Owner: <mailto:pgus-general-owner@postgresql.org>
List-Post: <mailto:pgus-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgus-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgus-general>
X-Mailing-List: pgus-general
Precedence: bulk
Sender: pgus-general-owner@postgresql.org

--94eb2c0930929d9921055498be4b
Content-Type: text/plain; charset="UTF-8"

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
>

--94eb2c0930929d9921055498be4b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Help anyone!?</div><div class=3D"gmail_extra"><br clear=3D"all"=
><div><div class=3D"m_-3867318443004654302m_-1671244794791916432m_-67994460=
08681881504gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"=
ltr"><div><font face=3D"verdana, sans-serif">Regards,</font></div><font fac=
e=3D"verdana, sans-serif">
</font><div><font face=3D"verdana, sans-serif">Prashanth<br>9989819107</fon=
t></div></div></div></div>
<br><div class=3D"gmail_quote">On Mon, Jul 17, 2017 at 8:27 PM, Prashanth R=
eddy <span dir=3D"ltr">&lt;<a href=3D"mailto:prash4783@gmail.com" target=3D=
"_blank">prash4783@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"auto">Hi,</div><div dir=3D"auto">Can you please provi=
de me the steps as how to stop the replication and open the standby databas=
e for read write and put the standby database back in sync with production.=
</div><span class=3D"m_-3867318443004654302m_-1671244794791916432m_-6799446=
008681881504HOEnZb"><font color=3D"#888888"><div dir=3D"ltr">-- <br></div><=
div data-smartmail=3D"gmail_signature">Sent from Gmail Mobile</div></font><=
/span></blockquote></div><br></div></div>

--94eb2c0930929d9921055498be4b--