Note that pgcluster is statement-based, which has some drawbacks. AFAIK
MySQL's 'clustering' is as well.
Many people use Slony to replicate to many slaves and use pgpool to hit
them. But remember if you do that you need to make sure any statement
that changes data hits your master and not the slaves. Command Prompt's
replication solution might also be useful.
On Tue, Oct 11, 2005 at 10:23:32AM -0600, Aly S.P Dharshi wrote:
> Hello Travis,
>
> I don't know if there are a Oracle RAC style cluster system for
> PGSQL but this software that can do something similar,
> http://pgcluster.projects.postgresql.org/feature.html may help.
>
> You can always use Slony for replication services.
>
> Cheers,
>
> Aly.
>
> On Mon, 10 Oct 2005, Travis Brady wrote:
>
> >All,
> >
> >Forgive me if this has been answered before, but I've searched the archives
> >and the net extensively and have come up mostly empty so far.
> >
> >I'm working at convincing my firm to implement a postgresql database
> >cluster.
> >Specifically, we'd like to get a few machines running to be more available
> >and to protect against any kind of failure.
> >
> >Right now people are leaning toward MySQL and Emic, but I've been
> >evangelizing for postgres for the standard reasons.
> >How does one go about setting this kind of thing up?
> >I've looked at Bizgres and Pervasive but I'm not sure if that's necessarily
> >what we want.
> >
> >thank you,
> >
> >Travis
> >
>
> --
> Aly S.P Dharshi
> aly.dharshi@telus.net
>
> "A good speech is like a good dress
> that's short enough to be interesting
> and long enough to cover the subject"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461