pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to stop Streaming Replication in slave for backup
6+ messages / 3 participants
[nested] [flat]
* How to stop Streaming Replication in slave for backup
@ 2017-02-02 18:07 Suresh Rajagopal <sureshr7@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Suresh Rajagopal @ 2017-02-02 18:07 UTC (permalink / raw)
To: pgsql-admin
Hi,
What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?
ThanksSuresh
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to stop Streaming Replication in slave for backup
@ 2017-02-02 18:23 Scott Whitney <scott@journyx.com>
parent: Suresh Rajagopal <sureshr7@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Scott Whitney @ 2017-02-02 18:23 UTC (permalink / raw)
To: pgsql-admin; Suresh Rajagopal <sureshr7@gmail.com>
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 <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 ?
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 promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to stop Streaming Replication in slave for backup
@ 2017-02-02 18:27 John Scalia <jayknowsunix@gmail.com>
parent: Suresh Rajagopal <sureshr7@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: John Scalia @ 2017-02-02 18:27 UTC (permalink / raw)
To: Suresh Rajagopal <sureshr7@gmail.com>; +Cc: pgsql-admin
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 <sureshr7@gmail.com> wrote:
> Hi,
>
> What is the best approach for stopping streaming replication on 9.3 slave
> for running pg_dump ?
>
> Thanks
> Suresh
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to stop Streaming Replication in slave for backup
@ 2017-02-02 18:58 Suresh Rajagopal <sureshr7@gmail.com>
parent: Scott Whitney <scott@journyx.com>
0 siblings, 0 replies; 6+ messages in thread
From: Suresh Rajagopal @ 2017-02-02 18:58 UTC (permalink / raw)
To: Scott Whitney <scott@journyx.com>; pgsql-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/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to stop Streaming Replication in slave for backup
@ 2017-02-02 18:59 Suresh Rajagopal <sureshr7@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Suresh Rajagopal @ 2017-02-02 18:59 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
Thanks John.
From: John Scalia <jayknowsunix@gmail.com>
To: Suresh Rajagopal <sureshr7@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
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 <sureshr7@gmail.com> wrote:
Hi,
What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?
ThanksSuresh
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to stop Streaming Replication in slave for backup
@ 2017-02-02 19:03 Scott Whitney <scott@journyx.com>
parent: Suresh Rajagopal <sureshr7@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Scott Whitney @ 2017-02-02 19:03 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; Suresh Rajagopal <sureshr7@gmail.com>; +Cc: pgsql-admin
Well...
In my personal experience, I have a multi GB customer database. During the PG dump, when the source (master) database is modified,
my pg_dump fails.
Pausing replication resolves that problem.
________________________________
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:59 PM
To: John Scalia
Cc: Pgsql-admin
Subject: Re: [ADMIN] How to stop Streaming Replication in slave for backup
Thanks John.
________________________________
From: John Scalia <jayknowsunix@gmail.com>
To: Suresh Rajagopal <sureshr7@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
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 <sureshr7@gmail.com<mailto:sureshr7@gmail.com>> wrote:
Hi,
What is the best approach 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 promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2017-02-02 19:03 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-02-02 18:07 How to stop Streaming Replication in slave for backup Suresh Rajagopal <sureshr7@gmail.com>
2017-02-02 18:23 ` Scott Whitney <scott@journyx.com>
2017-02-02 18:58 ` Suresh Rajagopal <sureshr7@gmail.com>
2017-02-02 18:27 ` John Scalia <jayknowsunix@gmail.com>
2017-02-02 18:59 ` Suresh Rajagopal <sureshr7@gmail.com>
2017-02-02 19:03 ` Scott Whitney <scott@journyx.com>
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