Warm standby server

Поиск
Список
Период
Сортировка
От Scott Whitney
Тема Warm standby server
Дата
Msg-id 20080626151632.E5CF63E20E4@mail.int.journyx.com
обсуждение исходный текст
Ответы Re: Warm standby server  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-admin
I've got 3 different database servers (db01, db02 and db03).

I would like to have a WAL standby server that replays logs for all 3 in
case one goes down, so I can promote that particular server.

Can I do this by installing 3 separate postmasters on this machine?
Obviously, if 2 went down at the same time, I'd have to do some magic to
bring up another machine, but I'm not sure that's a concern.

It'll be a RedHat RHEL-4 box on pg 8.1x



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

Предыдущее
От: Vishal Arora
Дата:
Сообщение: Re: Query
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: plpgsql function seems to be leaking memory