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 1E7CE11F6B1A for ; Wed, 5 Apr 2006 08:32:57 -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 13971-01 for ; Wed, 5 Apr 2006 08:32:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from blaster.systems.pipex.net (blaster.systems.pipex.net [62.241.163.7]) by postgresql.org (Postfix) with ESMTP id 2872811F6B2E for ; Wed, 5 Apr 2006 08:32:54 -0300 (ADT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by blaster.systems.pipex.net (Postfix) with ESMTP id B535CE00045A for ; Wed, 5 Apr 2006 12:32:51 +0100 (BST) Received: from elliot.edesix.com ([192.168.1.51]) by flange.edesix.com with esmtp (Exim 4.50) id 1FR6Fo-0002Gv-8I for pgsql-admin@postgresql.org; Wed, 05 Apr 2006 12:32:52 +0100 Message-ID: <4433AB17.7060705@edesix.com> Date: Wed, 05 Apr 2006 12:33:43 +0100 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: PITR Based replication ... 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.233 required=5 tests=[AWL=0.044, MISSING_HEADERS=0.189] X-Spam-Score: 0.233 X-Spam-Level: X-Archive-Number: 200604/54 X-Sequence-Number: 21223 Andy Shellam wrote: >Robin, > >On my part it's simply the fact that I currently have two servers in >different geographical locations - and cost of new hardware is a huge issue. > > >I have, however, recently developed an interest in rsync but I'm unsure as >to how PG on the standby server would handle a complete rsync'd data >directory. > >Andy > > Andy - agreed that DRBD is not appropriate for WAN-type environments (at least not unless the database is mostly read-only). There has just recently been a fairly extensive discussion on this list about how best to replicate the WAL files between two machines - I have no direct experience of this myself so will not comment on whether or not rsync is suitable. Cheers, Robin