Re: postgreSQL on NAS/SAN? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: postgreSQL on NAS/SAN?
Date
Msg-id 3EEF69B7.18105.18D1438@localhost
Whole thread Raw
In response to Re: postgreSQL on NAS/SAN?  ("Daniel Seichter" <daniel@dseichter.de>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Mattias Kregert"
Date:
Subject: Re: Difficulty with quotes
Next
From: Shane Dawalt
Date:
Subject: Re: full featured alter table?