Re: High Availability with Postgres

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: High Availability with Postgres
Дата
Msg-id 4C210966.7010601@hogranch.com
обсуждение исходный текст
Ответ на Re: High Availability with Postgres  (Dimitri Fontaine <dfontaine@hi-media.com>)
Ответы Re: High Availability with Postgres  (Dimitri Fontaine <dfontaine@hi-media.com>)
Re: High Availability with Postgres  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
On 06/22/10 1:58 AM, Dimitri Fontaine wrote:
> John R Pierce<pierce@hogranch.com>  writes:
>
>> failure modes can
>> include things like failing fans (which will be detected, resulting in a
>> server shutdown if too many fail), power supply failure (redundant PSUs, but
>> I've seen the power combining circuitry fail).   Any of these sorts of
>> failures will result in a failover without corrupting the data.
>>
>> and of course, intentional planned failovers to do OS maintenance...  you
>> patch the standby system, fail over to it and verify its good, then patch
>> the other system.
>>
> Ah, I see the use case much better now, thank you. And I begin too see
> how expensive reaching such a goal is, too. Going from "I can lose this
> many transactions" to "No data lost, ever" is at that price, though.
>

yeah.  generally when money is involved in the transactions, you gotta
stick to the 'no committed data lost ever'.  there's plenty of other use
cases for that too.



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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: what happens to postmaster?
Следующее
От: "Juba, Salahaldin I."
Дата:
Сообщение: SQL error: could not connect to database