X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 62AA511F640B for ; Wed, 5 Apr 2006 05:10:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79289-06 for ; Wed, 5 Apr 2006 05:10:20 -0300 (ADT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2956D11F6676 for ; Wed, 5 Apr 2006 05:09:47 -0300 (ADT) Received: from galaxy.systems.pipex.net (galaxy.systems.pipex.net [62.241.162.31]) by svr4.postgresql.org (Postfix) with ESMTP id 4A9255AF8A3 for ; Wed, 5 Apr 2006 08:09:45 +0000 (GMT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by galaxy.systems.pipex.net (Postfix) with ESMTP id C12B0E000189 for ; Wed, 5 Apr 2006 09:09:40 +0100 (BST) Received: from host86-131-245-51.range86-131.btcentralplus.com ([86.131.245.51] helo=[192.168.101.208]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FR358-0003gD-OI for pgsql-admin@postgresql.org; Wed, 05 Apr 2006 09:09:38 +0100 Message-ID: <44337B44.5050202@edesix.com> Date: Wed, 05 Apr 2006 09:09:40 +0100 From: Robin Iddon User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: PITR Based replication ... References: <20060404180206.U947@ganymede.hub.org> In-Reply-To: <20060404180206.U947@ganymede.hub.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.214 required=5 tests=[AWL=0.025, MISSING_HEADERS=0.189] X-Spam-Score: 0.214 X-Spam-Level: X-Archive-Number: 200604/51 X-Sequence-Number: 21220 Marc G. Fournier wrote: > > I know ppl are using it to do replication, but has anyone documented > what is involved in doing so? > > thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism that runs "underneath" the database rather than PITR between the database servers. I see a lot of interest on this list for the WAL copying solution, and I am wondering if that is because people have discounted a DRBD solution or that it has been overlooked? Thanks, Robin