X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E61FA8BA168 for ; Mon, 14 Feb 2005 17:40:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35007-07 for ; Mon, 14 Feb 2005 17:40:21 +0000 (GMT) Received: from entiat.olympus.net (entiat.olympus.net [65.117.224.69]) by svr1.postgresql.org (Postfix) with ESMTP id 812B38BA0F9 for ; Mon, 14 Feb 2005 17:40:20 +0000 (GMT) Received: from LoricaMail on entiat.olympus.net ([172.21.2.55] helo=entiat.olympus.net) by entiat.olympus.net with esmtp (Exim 4.42) id 1D0kCp-0008Oh-Dq for pgsql-admin@postgresql.org; Mon, 14 Feb 2005 09:40:19 -0800 Received: from tuk-dsl-226-242.olympus.net ([65.117.226.242]:32853 helo=[192.168.0.5]) by entiat.olympus.net with esmtpa (Exim 4.42) id 1D0kCh-0008Mz-Bf for pgsql-admin@postgresql.org; Mon, 14 Feb 2005 09:40:11 -0800 Message-ID: <4210E27A.60203@olympus.net> Date: Mon, 14 Feb 2005 09:40:10 -0800 From: Michael Klatt User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: replication References: <1108378262.3800.51.camel@localhost.localdomain> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virtual-Service: OlympusNet X-Exim-Id: 1D0kCh-0008Mz-Bf X-Olympus-MailID-CF: 1D0kCh-0008Mz-BfFeb14094011VUl X-Olympus-Virus: Scanned X-Olympus-OlympusNet: Initial processing complete X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/117 X-Sequence-Number: 16285 Christopher Browne wrote: > The world rejoiced as fred.blaise@excilan.com (Fred Blaise) wrote: > >>Hello >> >>I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one >>is a failover. I would like to implement a master-slave replication >>process. >> >>I believe replication has been included in the base package since 7.3.x. >> >>Do you have any good pointers/how-to to direct me to? > > > For such cases, I believe that Slony-I is the preferred solution these > days. The comprehensive documentation may be found in CVS at gborg; > it may be found online at the URL below. Hi Christopher, I've taken a look at Slony-I and found some limitations. Unless I'm mistaken, Slony-I can't be used to replicate users/groups, and it must be set up for each individual database. So, for a server where users and databases are added and removed often, then it seems like Slony-I may not be the best choice. For simply replicating data in a limited number of databases, then Slony-I probably performs much better than pgpool (which has many issues of its own). We're considering using Slony-I for some applications (where performance is an issue and user/databases don't change often) and pgpool for others (where we just need everything replicated). Michael