Re: warm standby with WAL shipping

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


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

Предыдущее
От: "Tim Bruce - Postgres"
Дата:
Сообщение: Re: High I/O writes activity on disks causing images on browser to lag and not load
Следующее
От: Terry Lee Tucker
Дата:
Сообщение: Re: warm standby with WAL shipping