Skip site navigation (1) Skip section navigation (2)

Re: Backup hot-standby database.

From: Robert Treat <rob(at)xzilla(dot)net>
To: Stephen Rees <srees(at)pandora(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup hot-standby database.
Date: 2011-03-21 15:49:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Fri, Mar 18, 2011 at 4:55 PM, Stephen Rees <srees(at)pandora(dot)com> wrote:
> Robert,
> Thank you for reply. I had the wrong end of the stick regarding pg_dump and
> hot-standby.
> I will take a look at omnipitr, as you suggest.
> Per your comment
>> You have to stop replay while you are doing the dumps like this
> how do I stop, then resume, replay with both the master and hot-standby
> available throughout?

If you are using WAL file based replication, you need some logic in
your restore script that will enable it to stop feeding xlog segments
into the slave (think "if pause file exists, return, else cp xlog
file"). This would leave the slave available, just with no updates
coming in.

If you are using streaming, I think it's much harder. There are some
new function to pause and resume streaming WAL coming in 9.1, it might
be possible to back-patch those, but we haven't looked at it yet.

Robert Treat

In response to

pgsql-admin by date

Next:From: Paul GrossDate: 2011-03-21 16:08:35
Subject: Restarting recovery mode with pg_standby after failure
Previous:From: Tapio PitkärantaDate: 2011-03-21 11:53:07
Subject: Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group