RE: clustering and/or failover?

what software are you running for this? where can i find it?

thanks!

rjsjr

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jim
> Buttafuoco
> Sent: Tuesday, August 21, 2001 6:53 AM
> To: Robert J. Sanford, Jr.; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] clustering and/or failover?
>
>
> Robert,
>
> I have been running a "heartbeat" PG database cluster for
> a year now using a shared SCSI bus.  Yes the heartbeat
> software has to be careful about when to mount the disk
> and on what system.   But this seems to work well (I did
> a lot of testing before putting into production.)  This
> is a pure master/standby cluster config.
>
> Jim
>
>
> > 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
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
> >
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>