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 E03B411F68D7 for ; Wed, 5 Apr 2006 05:45:51 -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 63458-06 for ; Wed, 5 Apr 2006 05:45:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 8B84311F68D2 for ; Wed, 5 Apr 2006 05:45:49 -0300 (ADT) Received: from [213.146.143.243] (port=1343 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FR3e7-0000Kp-Uv; Wed, 05 Apr 2006 09:45:47 +0100 Reply-To: From: "Andy Shellam" To: "'Robin Iddon'" Cc: Subject: Re: PITR Based replication ... Date: Wed, 5 Apr 2006 09:45:47 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-reply-to: <44337B44.5050202@edesix.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZYiH4JMNxhZ/S8QcCBSkAk8W38HAABCsiQ Message-Id: <20060405084549.8B84311F68D2@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.626 required=5 tests=[AWL=-0.301, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.626 X-Spam-Level: X-Archive-Number: 200604/53 X-Sequence-Number: 21222 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 > -----Original Message----- > From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin- > owner@postgresql.org] On Behalf Of Robin Iddon > Sent: 05 April 2006 9:10 am > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] PITR Based replication ... > > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > !DSPAM:14,44337b9c35048018610585! >