Re: PostgreSQL in Cluster

> Is there any way to use PostgreSQL in a cluster configuration or have
> redundancy?
> How can I have my DB to not stop on hardware failure?

You can have a fail-over cluster by having an external disk array
connected to two machines, where machine B is activated, mounts the
disks, and switches off power from machine A if it fails.

Jon

>
> Thank you,
>
> Luiz
>
> > On Friday 27 February 2004 18:31, Luiz Guilherme Freitas de Paula wrote:
> > > Hi everyone,
> > >
> > > Anyone have PostgreSQL running on a cluster?
> > > I'm trying to run on a OpenMosix 2-machine cluster but the processes are
> > > not migrating. All the load is concentrating in one machine.
> >
> > I don't think openmosix allows shared memory to migrate. Since PG uses
> shared
> > memory to communicate between backends, this will cause you problems.
> >
> > > And, how can I have fail over?
> >
> > More information?
> >
> > --
> >   Richard Huxton
> >   Archonet Ltd
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> >       subscribe-nomail command to majordomo@postgresql.org so that your
> >       message can get through to the mailing list cleanly
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>