Re: Backups over slave instead master?

[bricklen <bricklen@xxxxxxxxx>]

On Thu, May 15, 2014 at 1:55 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote:

On Thu, May  1, 2014 at 12:39:44PM -0700, bricklen wrote:
> 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?

 

Yes.