Re: Backups over slave instead master?

Em 01/05/2014 16:39, bricklen escreveu:
>
> On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas <sthomas(at)optionshouse(dot)com
> <mailto: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
Yes, backup = pg_dump.
Can I use it on slave even on 9.2.7?

Edson