Re: Clustered PostgreSQL

From: "Jojo Paderes" <jojo(dot)paderes(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Clustered PostgreSQL
Date: 2006-03-14 17:06:29
Message-ID: 65f9ddfb0603140906p27b841e2hdc12a7ee741346df@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We're currently using Ubuntu Breezy Hedgehog for our existing
PostgreSQL database server (8.0.x). A Java-based applications uses the
database server via JDBC.

I'm not sure if this question is within the context but I would like
to know if clustering can provide a hot-standby instance for a
production-running PostgreSQL server? Say if the main db server goes
down, another hot-standy with mirrored data from the main server can
be used to replaced the defective db server.

On 3/14/06, Louis Gonzales <louis(dot)gonzales(at)linuxlouis(dot)net> wrote:
>
> Slony-I is another cluster software for postgreSQL. What OS are you
> running? I just deployed it on Solaris 9, between a Sun Ultra
> Enterprise E450 and a Sun Ultra 30.
>
> It's really great. Currently, it only supports Single
> Master-to-multipleSlaves. Meaning, the single master is the only node
> where database updates can occur, the changes are then propagated to the
> slave nodes.
>
> http://gborg.postgresql.org/project/slony1/projdisplay.php
>

--
http://jojopaderes.multiply.com
http://jojopaderes.wordpress.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2006-03-14 17:08:58 Re: Resetting priveleges on a table
Previous Message Michael Fuhr 2006-03-14 16:23:34 Re: Utility of GRANT EXECUTE