Clustering with PostgreSQL?
All,
I'm wondering if PostgreSQL is capable of being setup in a clustering
configuration like one can setup for MSSQL server? We are seriously
considering a move to PostgreSQL, but this is probably the only item I
haven't seen available. We are setting up an ASP-based website and need to
have a seriously fault tolerant backend in place.
Any thoughts or comments regarding the 'appropriate' or 'recommended' type
of configuration for such a system would be greatly appreciated.
Thanks...Bobbo ;-)
Bob McCormick
Intuitive Software Technology
There is no inherent clustering or replication built into postgres yet. Version
7.2 promises replication on various levels.
For fault tolerance, I am sucessfully using drbd and heartbeat to failover
machines.
see http://www.complang.tuwien.ac.at/reisner/drbd/
Marc Wrubleski
Bob McCormick wrote:
Show quoted text
All,
I'm wondering if PostgreSQL is capable of being setup in a clustering
configuration like one can setup for MSSQL server? We are seriously
considering a move to PostgreSQL, but this is probably the only item I
haven't seen available. We are setting up an ASP-based website and need to
have a seriously fault tolerant backend in place.Any thoughts or comments regarding the 'appropriate' or 'recommended' type
of configuration for such a system would be greatly appreciated.Thanks...Bobbo ;-)
Bob McCormick
Intuitive Software Technology---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
And is there a semi-scheduled release for 7.2?
:-)
Clustering would be awesome, if not imperative.
Dan
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Marc Wrubleski
Sent: Tuesday, April 17, 2001 1:20 PM
To: Bob McCormick
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Clustering with PostgreSQL?There is no inherent clustering or replication built into postgres
yet. Version
7.2 promises replication on various levels.For fault tolerance, I am sucessfully using drbd and heartbeat to failover
machines.see http://www.complang.tuwien.ac.at/reisner/drbd/
Marc Wrubleski
Bob McCormick wrote:
All,
I'm wondering if PostgreSQL is capable of being setup in a clustering
configuration like one can setup for MSSQL server? We are seriously
considering a move to PostgreSQL, but this is probably the only item I
haven't seen available. We are setting up an ASP-based website and need to
have a seriously fault tolerant backend in place.Any thoughts or comments regarding the 'appropriate' or 'recommended' type
of configuration for such a system would be greatly appreciated.Thanks...Bobbo ;-)
Bob McCormick
Intuitive Software Technology---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?---------------------------(end of broadcast)---------------------------
TIP 3: 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