Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 820C29FC0DA for ; Fri, 15 Jun 2007 05:28:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 01993-03 for ; Fri, 15 Jun 2007 05:28:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id 028D29FC0D8 for ; Fri, 15 Jun 2007 05:28:34 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id s16so731248wxc for ; Fri, 15 Jun 2007 01:28:33 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=rqhZuc8OaW6m9M3po0dLhhQHerusoKKPMJKSRwOygx5XNrDvw5CBRuw6wwpri74pkTgqwDl/rkxCCvvir+aC1Uwou16KeuWJCKu8Bayv5d9meoyRdO+6prVONvAkAsNJmqwfSHbteLZbPAYPsXwLQzsNZcgUgHrOAvB0M+qyOHw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=jhBHwHxg38NB/fTwjjMz5S/9ikN1BcB8ygB4im9yrHMypj+k7qXov3TJ1IgR7NAbc+D2PQbNbGBcSFb5Qb57uh0E2oN+U0rt/Jr//cX3FQvBekmaZ0p8Tk1z38pQqua3/KjibR6EWfPvYN20pNfskJ06Q3UsszEFxLhSQPXylgo= Received: by 10.78.184.2 with SMTP id h2mr1114532huf.1181896113098; Fri, 15 Jun 2007 01:28:33 -0700 (PDT) Received: by 10.78.145.14 with HTTP; Fri, 15 Jun 2007 01:28:33 -0700 (PDT) Message-ID: <88daf38c0706150128j3560a52ct4bd7979802398c3c@mail.gmail.com> Date: Fri, 15 Jun 2007 10:28:33 +0200 From: "Alexander Staubo" To: "Craig James" Subject: Re: Replication Cc: "Andreas Kostyrka" , pgsql-performance@postgresql.org In-Reply-To: <4671EF14.7000002@emolecules.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4671CBBA.6010104@emolecules.com> <4671DF69.9090504@emolecules.com> <4671E517.5010102@kostyrka.org> <4671EF14.7000002@emolecules.com> X-Google-Sender-Auth: efbeb35676c9d9aa X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/276 X-Sequence-Number: 25309 On 6/15/07, Craig James wrote: > I don't think I can use PGPool as the replicator, because then it becomes a new single point of failure that could bring the whole system down. If you're using it for INSERT/UPDATE, then there can only be one PGPool server. Are you sure? I have been considering this possibility, too, but I didn't find anything in the documentation. The main mechanism of the proxy is taking received updates and playing them one multiple servers with 2PC, and the proxies should not need to keep any state about this, so why couldn't you install multiple proxies? Alexander.