From: | Suresh Rajagopal <sureshr7(at)gmail(dot)com> |
---|---|
To: | Scott Whitney <scott(at)journyx(dot)com>, Pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to stop Streaming Replication in slave for backup |
Date: | 2017-02-02 18:58:53 |
Message-ID: | 1884048112.425051.1486061933418@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Scott,
After i run pause, i see wal receiver is running. Is that okay ?
ThanksSuresh
From: Scott Whitney <scott(at)journyx(dot)com>
To: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>; Suresh Rajagopal <sureshr7(at)gmail(dot)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(at)postgresql(dot)org <pgsql-admin-owner(at)postgresql(dot)org> on behalf of Suresh Rajagopal <sureshr7(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Suresh Rajagopal | 2017-02-02 18:59:31 | Re: How to stop Streaming Replication in slave for backup |
Previous Message | John Scalia | 2017-02-02 18:27:23 | Re: How to stop Streaming Replication in slave for backup |