From: Suresh Rajagopal <sureshr7@gmail.com>
To: Scott Whitney <scott@journyx.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: How to stop Streaming Replication in slave for backup
Date: Thu, 2 Feb 2017 18:58:53 +0000 (UTC)
Message-ID: <1884048112.425051.1486061933418@mail.yahoo.com> (raw)
In-Reply-To: <BY1PR11MB039087CD630CD6708C334422A74C0@BY1PR11MB0390.namprd11.prod.outlook.com>
References: <673697488.421202.1486058849724.ref@mail.yahoo.com>
<673697488.421202.1486058849724@mail.yahoo.com>
<BY1PR11MB039087CD630CD6708C334422A74C0@BY1PR11MB0390.namprd11.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi Scott,
After i run pause, i see wal receiver is running. Is that okay ?
ThanksSuresh
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
#yiv7771702495 #yiv7771702495 -- P {margin-top:0;margin-bottom:0;}#yiv7771702495 I use:
SELECT pg_xlog_replay_pause();
-- pg_dumps run hereSELECT pg_xlog_replay_resume();
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Suresh Rajagopal <sureshr7@gmail.com>
Sent: Thursday, February 2, 2017 12:07 PM
To: Pgsql-admin
Subject: [ADMIN] How to stop Streaming Replication in slave for backup Hi,
What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?
ThanksSuresh
Journyx, Inc.7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888 f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sureshr7@gmail.com, scott@journyx.com
Subject: Re: How to stop Streaming Replication in slave for backup
In-Reply-To: <1884048112.425051.1486061933418@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox