Обсуждение: [ADMIN] How to stop Streaming Replication in slave for backup

Поиск
Список
Период
Сортировка

[ADMIN] How to stop Streaming Replication in slave for backup

От
Suresh Rajagopal
Дата:
Hi,

What is the best approach for stopping streaming replication on 9.3 slave for running pg_dump ?

Thanks
Suresh

Re: [ADMIN] How to stop Streaming Replication in slave for backup

От
Scott Whitney
Дата:

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/ 

Re: [ADMIN] How to stop Streaming Replication in slave for backup

От
John Scalia
Дата:
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

Re: [ADMIN] How to stop Streaming Replication in slave for backup

От
Suresh Rajagopal
Дата:
Hi Scott,

After i run pause, i see wal receiver is running. Is that okay ?

Thanks
Suresh


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 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/ 


Re: [ADMIN] How to stop Streaming Replication in slave for backup

От
Suresh Rajagopal
Дата:
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 ?

Thanks
Suresh



Re: [ADMIN] How to stop Streaming Replication in slave for backup

От
Scott Whitney
Дата:

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> 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/