From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | Shaun Thomas <sthomas(at)optionshouse(dot)com>, Edson Richter <edsonrichter(at)hotmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Backups over slave instead master? |
Date: | 2014-05-15 20:55:31 |
Message-ID: | 20140515205531.GC25052@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, May 1, 2014 at 12:39:44PM -0700, bricklen wrote:
>
> On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas <sthomas(at)optionshouse(dot)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
Uh, what is the pause for? So the transaction will not be cancelled?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2014-05-15 22:37:57 | Somebody hijacked @psql ? |
Previous Message | Diego Ramón Cando Díaz | 2014-05-15 20:52:42 | Questions about DB capabilities |