Re: Clustering

From: Patrick Haugen <pathaugen(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Clustering
Date: 2005-04-29 15:34:55
Message-ID: 9fd5eec80504290834cf5deec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Hilbert(at)gmx(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Böck 2005-04-29 15:35:04 Re: Problem with GIST-index and timestamps
Previous Message Tony Caduto 2005-04-29 15:14:50 Re: temp tables ORACLE/PGSQL