Re: postgreSQL on NAS/SAN?

On 17 Jun 2003 at 15:41, Daniel Seichter wrote:

> Hello Scott,
>
> > Are you looking more for failover, load balancing, hot
> > spare?
> I am looking for a hot spare, so if one server crashed, the second will
> "spare" it, because if this database will be down (down is meant for longer
> than 2 hours) more than two other databases will not continue working (they
> could continue working, but without new data, so it will be senseless).

If you have upto 2 hours to work with, may be you could go for asynchronous
replication solutions based on replicated checkpointed WAL segments.

Using those solutions+round robin DNS plus heartbeat service should yield what
you are looking for..

Bye
 Shridhar

--
Senate, n.:    A body of elderly gentlemen charged with high duties and
misdemeanors.        -- Ambrose Bierce