Re: warm standby with WAL shipping

On Wed, 2009-06-03 at 16:45 -0400, Terry Lee Tucker wrote:

> > --
> > * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>
> Our circumstance here is that we will be feeding multiple warm stand-by
> servers; one local and the rest remote, that is, at least one in other state
> and possibly another in another city. We didn't want the WAL shipping process
> to fail because one of the nodes might be down. To circumvent that, we
> thought the best approach to take was to pump the WAL logs to a central
> machine on-site, and have the warm stand-by servers pick up their files from
> the central storage device. This is why we were thinking about changing
> pg_standby.

PITRTools 1.2 has queuing which can deal with this problem.

I don't know if walmgr does.

Joshua D. Drake

>
> Thanks for all the help...
> --
>
> Work: 1-336-372-6812
> Cell: 1-336-404-6987
> email: terry(at)chosen-ones(dot)org
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997