On Fri, Mar 18, 2011 at 4:55 PM, Stephen Rees <srees(at)pandora(dot)com> wrote:
> Thank you for reply. I had the wrong end of the stick regarding pg_dump and
> 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
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.
In response to
pgsql-admin by date
|Next:||From: Paul Gross||Date: 2011-03-21 16:08:35|
|Subject: Restarting recovery mode with pg_standby after failure|
|Previous:||From: Tapio Pitkäranta||Date: 2011-03-21 11:53:07|
|Subject: Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory