Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement it?

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Hi,

On Tue, 14 Mar 2006, Jojo Paderes wrote:

> Is it possible to cluster PostgreSQL? If yes where can I find the
> resource information on how to implement it?

You can use pgcluster: http://pgcluster.projects.postgresql.org/ (I
haven't tried it yet)

Of course, you can install any clustering software (like Red Hat Cluster
Suite) if you want an active-passive cluster.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Jojo Paderes wrote:

>Is it possible to cluster PostgreSQL? If yes where can I find the
>resource information on how to implement it?
>
>--
>http://jojopaderes.multiply.com
>http://jojopaderes.wordpress.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
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/...rojdisplay.php

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a good option.

Regards,
Thomas Hallgren


Devrim GUNDUZ wrote:
>
> Hi,
>
> On Tue, 14 Mar 2006, Jojo Paderes wrote:
>
>> Is it possible to cluster PostgreSQL? If yes where can I find the
>> resource information on how to implement it?
>
> You can use pgcluster: http://pgcluster.projects.postgresql.org/ (I
> haven't tried it yet)
>
> Of course, you can install any clustering software (like Red Hat Cluster
> Suite) if you want an active-passive cluster.
>
> Regards,
> --
> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Hi,

On Tue, 14 Mar 2006, Thomas Hallgren wrote:

> If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a
> good option.

Definitely. I've read some papers on C-JDBC 3 years ago, and was really
satisfies with its features.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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.gonzales@linuxlouis.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/...rojdisplay.php
>


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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hi,

On Tue, 2006-03-14 at 11:08 -0700, Brendan Duddridge wrote:
> Do you know if pgcluster will work with PostgreSQL 8.1.3?

I haven't tested but as far as I can read from web page, 1.5.0rc1 works
on 8.1.1 -- They now have rc7, and maybe it works on 8.1.3, but I don't
know...

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Jojo Paderes wrote:

>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.
>
>
PgPool or Slony-I could be used for this. The difference being that
PgPool is statement level and thus may not be usable in some
environments. It is also synchronous. Slony-I is row-level and async,
but if your system goes down you may lose a small amount of unreplicated
data during the switchover.

YMMV...

HTH,
Chris Travers
Metatron Technology Consulting

>On 3/14/06, Louis Gonzales <louis.gonzales@linuxlouis.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/...rojdisplay.php
>>
>>
>>
>
>
>--
>http://jojopaderes.multiply.com
>http://jojopaderes.wordpress.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster