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 AC6DF8B9EFE for ; Mon, 14 Feb 2005 18:27:12 +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 43108-02 for ; Mon, 14 Feb 2005 18:27:06 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 14AA58B9EF9 for ; Mon, 14 Feb 2005 18:27:04 +0000 (GMT) Received: from [192.168.1.51] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j1EIR18p007614; Mon, 14 Feb 2005 10:27:02 -0800 Message-ID: <4210ED68.6090602@commandprompt.com> Date: Mon, 14 Feb 2005 10:26:48 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Fred Blaise Cc: pgsql-admin@postgresql.org Subject: Re: replication References: <1108378262.3800.51.camel@localhost.localdomain> In-Reply-To: <1108378262.3800.51.camel@localhost.localdomain> Content-Type: multipart/mixed; boundary="------------060508090509050708080406" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200502/118 X-Sequence-Number: 16286 This is a multi-part message in MIME format. --------------060508090509050708080406 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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. Hello, There are two major replication options for PostgreSQL. Once is Slony-I and one is Mammoth Replicator. Their respective websites are here: http://www.slony.info/ http://www.commandprompt.com/ Sincerely, Joshua D. Drake > > Do you have any good pointers/how-to to direct me to? > > Thanks for the help. > > Best, > > ))fred -- Command Prompt, Inc., your source for PostgreSQL replication, professional support, programming, managed services, shared and dedicated hosting. Home of the Open Source Projects plPHP, plPerlNG, pgManage, and pgPHPtoolkit. Contact us now at: +1-503-667-4564 - http://www.commandprompt.com --------------060508090509050708080406 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------060508090509050708080406--