Re: Clustering - Mailing list pgsql-general

From Patrick Haugen
Subject Re: Clustering
Date
Msg-id 9fd5eec80504290834cf5deec@mail.gmail.com
Whole thread Raw
In response to Re: Clustering  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
From the title alone, "pgCluster" sounded like the perfect choice for
PostgreSQL clustering.

However on their homepage they provide very little information is a
rough english traslation from what it sounds like. Also:

http://pgcluster.projects.postgresql.org/feature.html

What happens when the load balancer or replicator goes down? Doesn't
seem completly stable to me unless I'm missing something. Does anyone
have experience with this?

slony1 seems to cut out the balancer and replicator and leave the
fallover on server crash for you to figure out. I'm liking the sound
of this, however again it's tough to find decent readups on the
workings of this program.

I found this PDF:
http://developer.postgresql.org/~wieck/slony1/Slony-I-concept.pdf

Provided interesting information, however I'm wondering does anyone
know a site that explains it more? Know of any more online writeups in
PDF format? Most importantly, anyone have good experience with this?

Thanks for the info,
~PatHaugen

On 4/28/05, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> > Slony-I isn't clustering. They would have to look at pgCluster or
> > something like that.
> Sure but it seemed to fit their description of what they
> wanted to do.
>
> Karsten
> --
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: temp tables ORACLE/PGSQL
Next
From: Sebastian Böck
Date:
Subject: Re: Problem with GIST-index and timestamps