Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D4D019FA20E for ; Wed, 20 Dec 2006 11:50:52 -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 35715-10 for ; Wed, 20 Dec 2006 11:50:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx.mall.cz (mx.mall.cz [82.100.0.98]) by postgresql.org (Postfix) with ESMTP id 390FC9F9C35 for ; Wed, 20 Dec 2006 11:50:41 -0400 (AST) Received: by mx.mall.cz (Postfix, from userid 80) id 84F9513F618; Wed, 20 Dec 2006 16:50:39 +0100 (CET) Received: from localhost (asterix [127.0.0.1]) by mx.mall.cz (Postfix) with ESMTP id 73CBA13F617 for ; Wed, 20 Dec 2006 16:50:39 +0100 (CET) Received: from mx.mall.cz ([127.0.0.1]) by localhost (asterix [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29992-08 for ; Wed, 20 Dec 2006 16:50:32 +0100 (CET) Message-ID: <45895BAB.9040203@mall.cz> Date: Wed, 20 Dec 2006 16:50:03 +0100 From: Michal Taborsky - Internet Mall Organization: Internet Mall, a.s. User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Question: Clustering & Load Balancing References: <45891DB6.7020309@gmail.com> In-Reply-To: <45891DB6.7020309@gmail.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/490 X-Sequence-Number: 22546 CARMODA napsal(a): > has anyone here had any good/bad experiences clustering & load balancing > a PostgreSQL server on Redhat (ES)? We have recently successfully rolled-out a solution consisting of two PostgreSQL database backends replicated by Slony. The backends are accessed from a bunch of application servers (Apache) via pgpool. We have some shell scripts around it to handle monitoring, failover and switch-over. It is built on CentOS4 (ie. RedHat ES4). It's pretty solid. -- Michal Táborský chief systems architect Internet Mall, a.s.