Re: high availability

> If you want automated failover, PostgreSQL, Inc. say they'll sell you
> something which can do it.  I am suspicious of the assumptions behind
> the approach, but I haven;t investigated it deeply.
>
> If what you want is 100% guaranteed uptime with no interruptions for
> maintenance, I don't really think Postgres can do it yet.

I don't think anyone can do this yet.  Some may advertise it, but the
reality usually is different from the advertisements.  Some may be better,
or even much better than Postgres, but even when I worked at EDS, we had
to take down our production databases for very large web sites to do
certain maintenance tasks.

In fact, there, the most usual way of having a nonstop DB was just running
a DB on ultra-reliable hardware.  All of the CPUs were used CPUs that had
never shown any faults - same with memory.

Jon

>
> A
>
> --
> ----
> Andrew Sullivan                         204-4141 Yonge Street
> Liberty RMS                           Toronto, Ontario Canada
> <andrew@libertyrms.info>                              M2P 2A8
>                                          +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>