From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: High Availability with Postgres |
Date: | 2010-06-22 08:58:05 |
Message-ID: | 87bpb3qw9u.fsf@hi-media-techno.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
John R Pierce <pierce(at)hogranch(dot)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.
Regards,
--
dim
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2010-06-22 09:08:02 | Re: Hot Standby switchover |
Previous Message | Dimitri Fontaine | 2010-06-22 08:49:00 | Re: What type of index should I use? |