Re: Backups over slave instead master?

From: bricklen <bricklen(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backups over slave instead master?
Date: 2014-05-16 04:36:03
Message-ID: CAGrpgQ8-s7HdxuDeWA96D-vsX0kjPP2NuGxsoO2GU=R430JY6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chiru r 2014-05-16 07:19:25 Re: Backups over slave instead master?
Previous Message Martín Marqués 2014-05-15 22:37:57 Somebody hijacked @psql ?