Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cZMax-0003ty-OF for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:59:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cZMax-000671-BR for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:58:59 +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 ) id 1cZMaw-00066e-J8 for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:58:58 +0000 Received: from mail-it0-x229.google.com ([2607:f8b0:4001:c0b::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cZMat-0000vA-Ml for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:58:57 +0000 Received: by mail-it0-x229.google.com with SMTP id 203so46238462ith.0 for ; Thu, 02 Feb 2017 10:58:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:reply-to:to:message-id:in-reply-to:references:subject :mime-version:content-length; bh=Xp4og24sQiZ6Szu2qRdxSmiQoQKAlUtI6qNo5EvrAHE=; b=W2/STlGpEmS5ieU7OTh+tooaQcxntxMNT3mjP4j0Igy5kXNVFjAhekqjinZXvnb3fQ /oFc7W78BZdKPWIoHyd7gB7qxoUMxfoAppXdLI/jq7UbHC3SFP+3RkFh74GB5v6f79kY 96VA2EDiBLsh3zJOJ359aI4cSkI/QXykscVsDMjP3WdvsXCKGaip6oKapjdM55Uo7fEc /StcnbMjllc3syX1E93vbr2460ZCML9/nYtkdIv8Ihrco1ZUTlACgJVrADevO02CJYpH 3A4QAeefxf87OxNK1/j4wITk8eyKLStuZG62Q3MnACobbTftnPAevINpPWCgyVpn3Lnb 7jcg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:reply-to:to:message-id:in-reply-to :references:subject:mime-version:content-length; bh=Xp4og24sQiZ6Szu2qRdxSmiQoQKAlUtI6qNo5EvrAHE=; b=QWtt4fVZFEJWe6RSiebHam/J7LuVJqfFgPNuczLH2K/Cfn+w7IvbyC1AagkcOxWMGS G3057zDQK46O387o/rmumkWO8NdgTdnFifYKNRBeF9j2AnliN0fDFgljrEPs0thixMXn Dtapl1Vj/GphtFaMPrwFS+jV0JX0+DgA8/j+d96O06VS8MoF1NdP2FuJPueeV0zBIpAm kzHQRyEBnN1TXF4ShgVsLjcW1aAmPd3+PC1CeZL3T9GJ2RQ+6S9tbAg7vxerGb9ow1vL jaPDoYXu3SFzAB0FgTuBqQKFAclALVuxlH2Dq2RhXS+2Gk0FxaCd/SUfdGOhsDAPKTQL 9pfA== X-Gm-Message-State: AIkVDXKD1lRD08XeNIWjnU+SjOMZJu92EzAP4xoAJYlejlFBBVjnCn1tcW0Jq7IopDDnSw== X-Received: by 10.36.77.149 with SMTP id l143mr28463919itb.19.1486061934881; Thu, 02 Feb 2017 10:58:54 -0800 (PST) Received: from smtpsendws101.mail.ne1.yahoo.com (smtpsendws101.mail.ne1.yahoo.com. [98.138.101.178]) by smtp.gmail.com with ESMTPSA id 82sm1320743ion.40.2017.02.02.10.58.54 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 02 Feb 2017 10:58:54 -0800 (PST) X-YMail-OSG: RSB9Ub0VM1nCDpOdRsTiLWrnJi2FH.5lLv15U9S8YMsTwTkr4IK.itZyGriD3.y ldiqUpKWyKe4JRp84acfWxJNcYaQeBAuOauBo6IIPLh.X_UaNloI0HB5Si5zLSkbrSPa82NUjZUC lXXuQ8yfffwjyOwAuSDUWQPK.KqPzLJ5zmVU8yh1F2fKmmlEjwmMv7r0Ycxrs5UJXpHrIbsCLKob nfQPUm7lq2YOkQGH20NtxXmC1J37DIWaCSZ03Qkk2AgpWuqoOmi6VfW0DUsjbYl_7wQr88N.iPGE QipJd8NAzKgcKqoJhA2hP_fAkBb.e5qajgVendCNtK.nBoxtpyc..ZSFN7pHJn3g4KR5PbVW1AW0 3n0Lv7tnNt3B0JywosHLg17S3yxFTC2I2OJCgSuwUxM0djxqETx9.B2Ty0cBw1CyxtGN72_m5lm8 BrW0hB6sGgJMyKaeTKyTvRtP8O0UVCZrvrn7NVOVAGD91S6ugvdzXfAk5MR379sV_jmSlZC_zrig vgs35ij9J2n_r6gWVsdfaAJudH.TZ6R481k1VlLFb3HnUMfLWLw-- Received: from jws200156.mail.ne1.yahoo.com by smtpsendws101.mail.ne1.yahoo.com; Thu, 02 Feb 2017 18:58:53 +0000; 1486061933.635 Date: Thu, 2 Feb 2017 18:58:53 +0000 (UTC) From: Suresh Rajagopal Reply-To: Suresh Rajagopal To: Scott Whitney , Pgsql-admin Message-ID: <1884048112.425051.1486061933418@mail.yahoo.com> In-Reply-To: References: <673697488.421202.1486058849724.ref@mail.yahoo.com> <673697488.421202.1486058849724@mail.yahoo.com> Subject: Re: How to stop Streaming Replication in slave for backup MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_425050_1581129464.1486061933416" Content-Length: 8005 X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_425050_1581129464.1486061933416 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Scott, After i run pause, i see wal receiver is running. Is that okay ? ThanksSuresh From: Scott Whitney To: Pgsql-admin ; Suresh Rajagopal =20 Sent: Thursday, February 2, 2017 10:23 AM Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup =20 #yiv7771702495 #yiv7771702495 -- P {margin-top:0;margin-bottom:0;}#yiv77717= 02495 I use: SELECT pg_xlog_replay_pause(); -- pg_dumps run hereSELECT pg_xlog_replay_resume(); From: pgsql-admin-owner@postgresql.org o= n behalf of Suresh Rajagopal Sent: Thursday, February 2, 2017 12:07 PM To: Pgsql-admin Subject: [ADMIN] How to stop Streaming Replication in slave for backup=C2= =A0Hi, What is the best approach for stopping streaming replication on 9.3 slave f= or running pg_dump ? ThanksSuresh Journyx, Inc.7600 Burnet Road #300=20 Austin, TX 78757=20 www.journyx.com=20 p 512.834.8888=C2=A0f 512-834-8858=C2=A0 Do you receive our promotional emails? You can subscribe or unsubscribe to = those emails at http://go.journyx.com/emailPreference/e/4932/714/=C2=A0 =20 ------=_Part_425050_1581129464.1486061933416 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Scott,

After i run pause, = i see wal receiver is running. Is that okay ?

Thanks
Suresh=


From: Scott Whitney <scott@journyx.com>
To: Pgsql-admin <= pgsql-admin@postgresql.org>; Suresh Rajagopal <sureshr7@gmail.com>=
Sent: Thursday, February 2, 2017 10:23 AM
Subject: Re: [ADMIN] How to stop Streaming Replication in = slave for backup

I use:

SELECT pg_xlog_replay_pause();
-- pg_dumps run here
SELECT pg_xlog_replay_resume();



From: pgsql-admin-owner@postgresql.org <= ;pgsql-admin-owner@postgresql.org> on behalf of Suresh Rajagopal <sur= eshr7@gmail.com>
Sent: Thursday, February 2, 2017 12:07 PM
To: Pgsql-admin
Subject: [ADMIN] How t= o stop Streaming Replication in slave for backup
 
Hi,

What is the best approac= h for stopping streaming replication on 9.3 slave for running pg_dump ?

Thanks
Suresh


Journyx, Inc.
7600 Burnet Road #300 Austin, TX 78757
www.journyx.com

p 512.834.8888 
f 512-834-8858 

Do you receive our promo= tional emails? You can subscribe or unsubscribe to those emails at http://g= o.journyx.com/emailPreference/e/4932/714/ 


------=_Part_425050_1581129464.1486061933416--