Re: warm standby with WAL shipping

On Wednesday 03 June 2009 17:11, Joshua D. Drake wrote:
> 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.
>

We will look into PITRTools then. I'm nervous about re-inventing the wheel as
has been pointed out.

Thanks for the input...

> 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

--
Work: 1-336-372-6812
Cell: 1-336-404-6987
email: terry(at)leetuckert(dot)net