Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cZMba-0003ug-MS for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:59:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cZMba-0006pS-9U for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:59:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cZMbZ-0006n8-7p for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:59:37 +0000 Received: from mail-it0-x243.google.com ([2607:f8b0:4001:c0b::243]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cZMbW-0002dl-OD for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:59:36 +0000 Received: by mail-it0-x243.google.com with SMTP id e137so61441itc.0 for ; Thu, 02 Feb 2017 10:59:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:reply-to:to:cc:message-id:in-reply-to:references:subject :mime-version:content-length; bh=kqv2L9aJSyzPsYdTQy9XqY/eWRbaAjiUMrDJyMbh+Iw=; b=oaVNrqejqU4XUm+QSMu4BaMdeSOTm9ZUnS9qYOdB2SqrUQ4Wkxo656/sBzqY22ThwK jwBVp2aW+sBbLwrq0LNHdf5FenaEwqOZVxbPSkuHHJO2tAtrLVJ1mMQdqoD5gZKRyRzN KfhDNIk54u2JXoheSQdKF0zzvIkvb/WSQpEznRvn0MS5Tu3N8Quexw9QExvCc59/oxKS DyUt7cyp22g1aebnvT+Ksl3prwwzYpO8QUiE/napI4VrkpFZynOOrA9DbYi8BM3LdAVa fBFBJTbrPejX6GuPrnlzW6/KMIdcoBJhpvpDiPXJVL1oMreYzB2hLME3XI9+/lNaJPPj qzjA== 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:cc:message-id:in-reply-to :references:subject:mime-version:content-length; bh=kqv2L9aJSyzPsYdTQy9XqY/eWRbaAjiUMrDJyMbh+Iw=; b=Ve72nP/axN3kaZF9jfqRD8i9JCOLHwNRS0I/2KdpdGLsZ18gtoHBIKX7nqwdXk47hp oVzZ2QU3QTR1mIDpoQfCDl58dCiuMjFyFjZ1L2spStbFPR9UwXf2W58wvGSkBTSKfl/j Ncrd9PNaMiCQ1jSUthz1kGgFcSXHSL37G7DfDZIuD+S8R0lucDeLrBJFKRILFAHj2ZxE UiECJ//xU5iwzAK/kQjZOHGgoTJudx88gyZQBLGf4PdIAgDAF0I7AWoEdgOaZL7IjF1r j3mwZIihV6hMapx87urVjp9Y1QKP4DfHGXrNSmxDI4Sgr0hWflCMRt6WIgXeg2JzPkwg uL/A== X-Gm-Message-State: AIkVDXKUNRDSw+fx1ykSWwsKTdYMowTqTbeQvzBPFkcnULUnKTwzao3XmtMKQGiHDiITzw== X-Received: by 10.36.211.133 with SMTP id n127mr28453717itg.29.1486061972727; Thu, 02 Feb 2017 10:59:32 -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 g76sm1324785ioj.36.2017.02.02.10.59.32 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 02 Feb 2017 10:59:32 -0800 (PST) X-YMail-OSG: uVWSrMIVM1lelyoOGDom5nCSYuraH.0vDNEfP.0WLTjp_mvRnV0DvDVxi6IljlD ZzbehBui7h49QlmUWGcVGCYcl4KdvAE6Eog4p6LS5LJaiDDmDhxnWgyQLJfBv6905r5wmZrpYgcN Xc69GhlDqNfx49pBz9TuqMXIunVDjjZRRimGA8XipaV7CRdaEzPYASSDY1e77erESoc8bE9E2Dhy 8idwaxQPpNr1oq7mL5yBL04x4pFkf_AP5etbbB9jR80VhFnDEZnhIV6SwvnNBLbxwvGWtCNQTcNX RC58gGjioBntDcRHcmAF7UTp3Bt.XU2gW4mdRyQ5VGr0mgXdfxSB5ipYKp7QHHyoH_NMwDsI4E1h EtrErEds_KB_wG3LimPsCBh9OiYQty.0btalcTLHxbPWCJkWLizZgiM.tVuRf1sQ5FxaqIFrfsEW 1f0CavVPDPYs.c8UMLo9yncvtIzHTcwWiefroq887xg0VpxVl5keipXj9SXOsWbWtI__q.WRvkTb OGzcI9rAZkD8AsSq45EQL9Pi09rnFqoPwLmiK0Piynbm1awZU_w-- Received: from jws200068.mail.ne1.yahoo.com by smtpsendws101.mail.ne1.yahoo.com; Thu, 02 Feb 2017 18:59:31 +0000; 1486061971.477 Date: Thu, 2 Feb 2017 18:59:31 +0000 (UTC) From: Suresh Rajagopal Reply-To: Suresh Rajagopal To: John Scalia Cc: Pgsql-admin Message-ID: <321798798.450676.1486061971279@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_450675_1716713539.1486061971277" Content-Length: 4273 X-Pg-Spam-Score: -1.5 (-) 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_450675_1716713539.1486061971277 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Thanks John. From: John Scalia To: Suresh Rajagopal Cc: Pgsql-admin Sent: Thursday, February 2, 2017 10:27 AM Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup You really shouldn't need to stop replication in order to run pg_dump on a 9.3 database, On Thu, Feb 2, 2017 at 1:07 PM, Suresh Rajagopal wrote: Hi, What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ? ThanksSuresh ------=_Part_450675_1716713539.1486061971277 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks John.


<= b>From: John Scalia <jaykno= wsunix@gmail.com>
To: Suresh Rajagopal <sureshr7@gmail.com>
Cc: Pgsql-admin <pgsql-admin@p= ostgresql.org>
Sent: Thursday, February 2, 2017 10:27 AM
Subject: Re: [ADMIN] How to stop Streaming Replication in s= lave for backup

You really shouldn't need to stop replicati= on in order to run pg_dump on a 9.3 database,

On Thu, Feb 2, 2017 at 1:07 PM, Suresh Raja= gopal <sureshr7@gmail.com> wrote:
Hi,

What is the best approach for stoppin= g streaming replication on 9.3 slave for running pg_dump ?

Thanks
Suresh



------=_Part_450675_1716713539.1486061971277--