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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxx -- Work: 1-336-372-6812 Cell: 1-336-404-6987 email: terry@xxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general