Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 200A09F9C35 for ; Wed, 20 Dec 2006 07:25:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 92833-08 for ; Wed, 20 Dec 2006 07:25:43 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 7173F9F9DAD for ; Wed, 20 Dec 2006 07:25:42 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so70783pye for ; Wed, 20 Dec 2006 03:25:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:organization:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=AmPrbpKpXlimW4zEJUxf4SocbVyLRcuzCXF0H5FONtiwIIK44Pux7mvbmnWWXq0ZCyH6Wnt20Pv6X6P3+EbKERfsXXYPUnYAMeor7O6O6xw/qv7hYRJpBrk8L6kmxt9wKtG1HbwDA+P7nzhdnemrgOjsafOMdZ6Bcr8BU4ELwCw= Received: by 10.65.38.13 with SMTP id q13mr9244304qbj.1166613941131; Wed, 20 Dec 2006 03:25:41 -0800 (PST) Received: from ?192.168.1.12? ( [203.206.107.93]) by mx.google.com with ESMTP id d12sm9925333qbc.2006.12.20.03.25.39; Wed, 20 Dec 2006 03:25:40 -0800 (PST) Message-ID: <45891DB6.7020309@gmail.com> Date: Wed, 20 Dec 2006 21:25:42 +1000 From: CARMODA Reply-To: carmoda@gmail.com Organization: CARMODA User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Question: Clustering & Load Balancing Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/488 X-Sequence-Number: 22544 Hi, has anyone here had any good/bad experiences clustering & load balancing a PostgreSQL server on Redhat (ES)? i have two identical servers with plenty of memory plus a nice disc array. the solution should have both redundancy and performance. BTW: it's a back end to a web based application in a high traffic situation. i thought it might be sensible to use a redhat cluster rather than introduce another ingredient like PGCluster given we 'can' use a RH cluster. any suggestions invited and appreciated.