Re: warm standby with WAL shipping

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

> > --
> > * Greg Smith gsmith@gregsmith.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@chosen-ones.org
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997