I assume you have read this new documentation for 8.2:
http://www.postgresql.org/docs/8.2/static/high-availability.html
---------------------------------------------------------------------------
[EMAIL PROTECTED] wrote:
> >Hi,
> >
> >I am currently investigating the preferred method of clustering a postgresql
> >database on Redhat?
> >
> >i would really appreciate some suggestions or experiences you guys have had.
> >
> >note: performance & redundancy are both equally desirable and i have plenty
> >of resources.
> >
> >we already have licences for Redhat Enterprise Linux ES v4, i was wondering
> >if Redhat's >Cluster Manager is a candidate? ~ or if either PGCluster or
> >Slony1 have >advantages or drawbacks etc.
>
> Couple of months ago, when I started looking at replication, and clustering I
> saw this as a fairly basic question, but the more I got into it the more I
> realized there's clustering, clustering and clustering, and replication,
> replication and replication.
> I dont think anyone can give you a prefered method, not without a system spec.
>
> I looked at Slony, even tried to help debug it on windows, and eventually
> realised its Master Slave arrangement would not work for me.
> I looked at dBMirror, which I liked in concept but I didnt fancy the way the
> code was done in a project that seems to be dead.
> Then I looked at some really weird and wonderful schemes that work on a core
> technology like a reliable message queue, not for me.
>
> In the end I decided I wanted real time synchronous multi master replication,
> without conflict resolution, and that I didnt really want a dBCluster, I
> needed to cluster and load balance at web level, allowing for things like
> session management, multiple clusters, and remote sites.
>
> Bad news is I couldnt find it, not for free anyway.
>
> If you dont find a solution, try http://spar.orgfree.com/index.html
> Please keep in mind, its new and written by a novice out of desparation, not
> one of the community super geeks, but it takes a very pragmatic approach to
> replication and maybe just what the doctor ordered.... Good Luck.
>
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
