Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EDFFD9F9463 for ; Tue, 30 Oct 2007 05:27:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 39623-04 for ; Tue, 30 Oct 2007 05:27:09 -0300 (ADT) X-Greylist: delayed 00:06:32.871614 by SQLgrey-1.7.5 Received: from mail.rentalia.com (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id A9E209F942B for ; Tue, 30 Oct 2007 05:27:12 -0300 (ADT) Received: (qmail 2549 invoked by uid 509); 30 Oct 2007 09:20:30 +0100 Received: from 81.33.147.149 by nemo (envelope-from , uid 507) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.7/2476. spamassassin: 3.0.6. perlscan: 1.25-st-qms. Clear:RC:0(81.33.147.149):SA:0(-2.6/5.0):. Processed in 0.211392 secs); 30 Oct 2007 08:20:30 -0000 X-Antivirus-MYDOMAIN-Mail-From: ruben@rentalia.com via nemo X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(81.33.147.149):SA:0(-2.6/5.0):. Processed in 0.211392 secs Process 2539) Received: from 149.red-81-33-147.dynamicip.rima-tde.net (HELO ?192.168.2.48?) (ruben@rentalia.com@81.33.147.149) by mail.rentalia.com with SMTP; 30 Oct 2007 09:20:29 +0100 Message-ID: <4726E948.4000204@rentalia.com> Date: Tue, 30 Oct 2007 09:20:24 +0100 From: ruben@rentalia.com Reply-To: ruben@rentalia.com User-Agent: Thunderbird 1.5.0.13 (X11/20070824) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: High Availability and Load Balancing Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/352 X-Sequence-Number: 27374 Hi, I need to implement a Load Balancing solution in the PostgresSQL database. Actually we are working with postgres 8.1 but postgres 8.2 is planified to be upgrade in short. I read about it, and would like to know any experience with this. Did you ever need Load Balancing? What did you implement? Is it working fine? Any big trouble? Thanks in advance,