clustering and/or failover?

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: clustering and/or failover?
Date: 2001-08-20 23:01:39
Message-ID: HAEKIEGIHMCDGLOIEKGMIECPCIAA.rsanford@nolimitsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thinking in the long-term for my project...

i'm looking at trying to set up two database servers with
some sort of clustering and/or failover that are talking
to a SAN. is this even feasible using postgres?

using ms sql server as an example (because that is what
my office is currently using) you can set up two database
servers that will check each other's heartbeat to see if
they are both up. if one goes down then the other takes
over responding to requests. you can also set up a
cluster that will have both machines responding to
requests concurrently.

with the data set up on a fibre channel raid box you
don't have to worry about replication, you just have to
make sure that the data is properly locked by each of
the servers (in the clustering example) so that no two
machines are updating the same data at the same time.

i am fairly certain that postgres cannot handle the
first example (heartbeats) but am wondering if it can
handle the second example where two instances are
hitting the same physical data store.

many thanks!

rjsjr

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2001-08-20 23:52:54 Re: Missing Sequence File
Previous Message Trond Eivind Glomsrød 2001-08-20 22:09:50 Re: New RPMS ?