I've set up a database cluster using PGCluster (pgcluster.org) and Slony (http://slony.info/) seems to be gaining a lot of traction recently. Both of which are free solutions. Commercial support is available for Slony, and as you say, there are a slew of commercial clustering solutions for PostgreSQL out there.
HTH Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Russ wrote: > Does it support clustering out of the box? From what I remember the only > solutions were commercial third party solutions. > > Russ > >> -----Original Message----- >> From: Jordan Michaels [mailto:[EMAIL PROTECTED] >> Sent: Monday, June 02, 2008 5:27 PM >> To: CF-Talk >> Subject: Re: CF with PostgreSQL >> >> I *adore* PostgreSQL and use it almost exclusively (unless told to use >> something else). >> >> It's got a slight learning curve as far as permissions goes, but once >> you're comfortable with that, PostgreSQL is small enough for tiny sites >> and scalable enough for multi-server clustering. It's benchmarks are >> also extremely impressive. >> >> Not to mention, you can't get much better then the BSD license! >> >> I highly recommend it to anyone. >> >> Warm regards, >> Jordan Michaels >> Vivio Technologies >> http://www.viviotech.net/ >> Open BlueDragon Steering Committee >> Adobe Solution Provider >> >> >> Wil Genovese wrote: >>> I have a general question. how many of you (us) CF'ers are using >>> PostgreSQL for their database? >>> >>> I've been using PostgreSQL for about 5 years. As I dig through >>> RIAForge I see many projects are coded explicitly for a certain DB >>> mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? >>> PostgreSQL is a powerful ACID compliant db server that is more than >>> capable of handling anything you can through at MS/MY SQL. >>> >>> Just looking for your thoughts and opinions. And if anyone knows of a >>> OO CF project that uses PostgreSQL. >>> >>> BTW: I know it usually does not take much to alter code to work with >>> PGsql. I already converted BlogCFC. >>> >>> >>> Wil Genovese >>> >>> One man with courage makes a majority. >>> -Andrew Jackson >>> >>> A fine is a tax for doing wrong. A tax is a fine for doing well. >>> >>> >>> >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
