Re: warm standby with WAL shipping

Поиск
Список
Период
Сортировка
От Terry Lee Tucker
Тема Re: warm standby with WAL shipping
Дата
Msg-id 200906031716.31063.terry@chosen-ones.org
обсуждение исходный текст
Ответ на Re: warm standby with WAL shipping  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
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@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.
>

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@chosen-ones.org

--
 Work: 1-336-372-6812
 Cell: 1-336-404-6987
email: terry@leetuckert.net

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: warm standby with WAL shipping
Следующее
От: Tom Lane
Дата:
Сообщение: Re: problem with FOUND and EXECUTE in pl/pgsql