Re: Backups over slave instead master? - Mailing list pgsql-general

From Edson Richter
Subject Re: Backups over slave instead master?
Date
Msg-id BLU436-SMTP498F2330B87C04F97F394ECF430@phx.gbl
Whole thread Raw
In response to Re: Backups over slave instead master?  (bricklen <bricklen@gmail.com>)
Responses Re: Backups over slave instead master?  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-general
Em 01/05/2014 16:39, bricklen escreveu:

On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas <sthomas@optionshouse.com> wrote:
On 05/01/2014 10:31 AM, Edson Richter wrote:

I'm wondering if would be possible to execute these backups in the slave
server instead, so I can avoid the overhead of backups on master system?

If you're on PostgreSQL 9.3, you can backup the slave server safely. If not, you'll need to run this command on the master system first:

SELECT pg_start_backup('some-label');

After the backup is done, run this on the master server:

SELECT pg_stop_backup();

Or alternatively, if "backup" = pg_dump, then backups can taken from the slave too. Have a look at pg_xlog_replay_pause() + pg_dump + pg_xlog_replay_resume().
http://www.postgresql.org/docs/current/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL-TABLE
Yes, backup = pg_dump.
Can I use it on slave even on 9.2.7?

Edson

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: break table into portions for writing to separate files
Next
From: Shaun Thomas
Date:
Subject: Re: Backups over slave instead master?