From: | Scott Whitney <scott(at)journyx(dot)com> |
---|---|
To: | John Scalia <jayknowsunix(at)gmail(dot)com>, Suresh Rajagopal <sureshr7(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to stop Streaming Replication in slave for backup |
Date: | 2017-02-02 19:03:48 |
Message-ID: | BY1PR11MB0390DAC52E08FD879A07B133A74C0@BY1PR11MB0390.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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: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(at)gmail(dot)com>
To: Suresh Rajagopal <sureshr7(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)postgresql(dot)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(at)gmail(dot)com<mailto:sureshr7(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Ganesh Kannan | 2017-02-08 06:48:10 | Recovery from Transaction wraparound failure |
Previous Message | Suresh Rajagopal | 2017-02-02 18:59:31 | Re: How to stop Streaming Replication in slave for backup |