Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46271=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cZLnG-0001zB-7f
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:07:38 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46271=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cZLnE-0008O4-D7
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Feb 2017 18:07:36 +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 <sureshr7@gmail.com>)
	id 1cZLnD-0008No-K8
	for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:07:35 +0000
Received: from mail-io0-x22c.google.com ([2607:f8b0:4001:c06::22c])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <sureshr7@gmail.com>)
	id 1cZLnB-0008Qi-12
	for pgsql-admin@postgresql.org; Thu, 02 Feb 2017 18:07:34 +0000
Received: by mail-io0-x22c.google.com with SMTP id j18so188008764ioe.2
        for <pgsql-admin@postgresql.org>;
 Thu, 02 Feb 2017 10:07:32 -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:subject:mime-version:references
         :content-length;
        bh=OS9u6mtQRQj0y1jtzYQfGBtYfdYuxAheNIEkg/+gDgA=;
        b=kzBnRz1F4702BddaH4Txi3YlKtl+r7quDu6mtyPUhkXC6Lbyezo30M1/ierD175CQ7
         3NTJLocVNyIWFhaHdUZOrW4qSwlOxZOsGuqkJJ+uT71/K9ogzqBgU63d6RrgIjvMQ/8U
         L9pKjcav4SCIJ2an5F8o7qAHosevZhrzGzjhBMoJXhCXiKiyX4AqV6z4LLLFH85JC0Su
         4f4h+N7J17uZjQq88VtoMzgl460TXW0bpHYT3tlIp/oPWJ5j3D9oB8il1G9N68H7Itr4
         DYtmiaSmKR2/dUJFm3HzGNlVyVjsQiDCk49jKT9p8U9AMwmKXPtw5XIGeaTpEsB0ERrw
         IBuw==
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:subject
         :mime-version:references:content-length;
        bh=OS9u6mtQRQj0y1jtzYQfGBtYfdYuxAheNIEkg/+gDgA=;
        b=I+dcbj9UPtCWFvAXd4k2/cPFAzz3d75XJY6l9pt65itPGaoMad59u9sWh6+z62Pqk8
         Lbn9kzVNBdHulHAIr1uOIhU0O6MrAwwub5hi+5tF/D7TRygfmTVJFerRRoA2JEtuaCBC
         8kCeksIE3gjlEV/a563TZFquFWO4oEI5SEapchU+ka3wWMJJHAH7Sb7evUMdrMo7neTI
         v6j1J+5A4ibbxwXKGa2ww6BIE9pptUgBLkrzgsKh2+rtzSo3Ye5Qd0zn3hggDOQ1QCgt
         fR4h300oV3fNtU4iRfAKr4WnWoLtgvha9dRxgN625ahAP/ZV7onf3u7Wp0WRy/QW3BzK
         beBw==
X-Gm-Message-State: 
 AIkVDXKtIanAd0xxlbrUugkG9JSHJKx1f6iquK8hp5xWKQe88n2D76VZla81PbYLfUEpZQ==
X-Received: by 10.107.59.69 with SMTP id i66mr7447831ioa.10.1486058851489;
        Thu, 02 Feb 2017 10:07:31 -0800 (PST)
Received: from smtpsendws102.mail.ne1.yahoo.com
 (smtpsendws102.mail.ne1.yahoo.com. [98.138.101.179])
        by smtp.gmail.com with ESMTPSA id 86sm1270258iok.8.2017.02.02.10.07.30
        for <pgsql-admin@postgresql.org>
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Thu, 02 Feb 2017 10:07:31 -0800 (PST)
X-YMail-OSG: hEGjtscVM1leINFyqXLlZaiJriABGkmrZd2FQAoh1LJiCqpPoXra5JwoBXqa.8W
 Op7Dfuj6MrRtlIn9zvDKIrim9M4NhcizeFCJjnahc6gM1OxIkjMzhKoReZuu_5IZga7nJvOHb.oQ
 m7cxDTwN6j.DNK28I7A0OG0r17w5C.HzT6mY8WooEhVACuOILKYnF1b_7ea4Epcxd5rdu2Cb5GNM
 EFpWrvBQMFsnaBzTQk9gnW6XdFKIXyHsWKdPfTpcPCaJIog2Tu6Mfmxq0Lz.hlrJ8LzjUCJ_E78z
 522qUVTF6xUWKqN3D_G7OLYXrR5M3rXOaTAn6xHN4Ca2dWoHeqUvL_owvhR2ZWaOfFeEIh0FuZao
 A6elvFb0X4zyXE2BpS2UEVawPtLh_KYrlE5N_tEr25zRIgXBPvgnuEc7mzmX3VoDYyKxDxdB9ODq
 lMudQx_SNurTXgC8yn3I9K1bwq98GQr91TN3kL06pi.UgjlPZNvgI6YaTQa6tozs.q2D6quop70_
 x.bDnmXA79GB_JyXYUVh14n0WyE3otcdWoyLcJPAFu.btfEksmA--
Received: from jws200007.mail.ne1.yahoo.com by
 smtpsendws102.mail.ne1.yahoo.com; Thu, 02 Feb 2017 18:07:29 +0000;
 1486058849.908
Date: Thu, 2 Feb 2017 18:07:29 +0000 (UTC)
From: Suresh Rajagopal <sureshr7@gmail.com>
Reply-To: Suresh Rajagopal <sureshr7@gmail.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <673697488.421202.1486058849724@mail.yahoo.com>
Subject: How to stop Streaming Replication in slave for backup
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_421201_392869247.1486058849723"
References: <673697488.421202.1486058849724.ref@mail.yahoo.com>
Content-Length: 812
X-Pg-Spam-Score: -2.2 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------=_Part_421201_392869247.1486058849723
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi,
What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?
ThanksSuresh
------=_Part_421201_392869247.1486058849723
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html><head></head><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1485989587763_116649">Hi,</div><div id="yui_3_16_0_ym19_1_1485989587763_116650"><br></div><div>What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?</div><div><br></div><div>Thanks</div><div>Suresh</div></div></body></html>
------=_Part_421201_392869247.1486058849723--