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

From bricklen
Subject Re: Backups over slave instead master?
Date
Msg-id CAGrpgQ8-s7HdxuDeWA96D-vsX0kjPP2NuGxsoO2GU=R430JY6A@mail.gmail.com
Whole thread Raw
In response to Re: Backups over slave instead master?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Backups over slave instead master?  (chiru r <chirupg@gmail.com>)
List pgsql-general

On Thu, May 15, 2014 at 1:55 PM, Bruce Momjian <bruce@momjian.us> 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.

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Somebody hijacked @psql ?
Next
From: chiru r
Date:
Subject: Re: Backups over slave instead master?