Search Postgresql Archives

Re: warm standby with WAL shipping

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux