X-Original-To: pgsql-hackers-pitr-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AE0C3D1B456 for ; Tue, 17 Feb 2004 00:08:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38849-08 for ; Mon, 16 Feb 2004 20:08:06 -0400 (AST) Received: from cmailg5.svr.pol.co.uk (cmailg5.svr.pol.co.uk [195.92.195.175]) by svr1.postgresql.org (Postfix) with ESMTP id BC9D7D1DD2C for ; Mon, 16 Feb 2004 20:08:03 -0400 (AST) Received: from modem-3521.leopard.dialup.pol.co.uk ([217.135.157.193] helo=LaptopDellXP) by cmailg5.svr.pol.co.uk with esmtp (Exim 4.14) id 1AssmU-0002jY-Ce; Tue, 17 Feb 2004 00:08:06 +0000 Reply-To: From: "Simon Riggs" To: "'Oli Sennhauser'" Cc: Subject: Re: Proposals for PITR Date: Mon, 16 Feb 2004 23:07:25 -0000 Organization: 2nd Quadrant Message-ID: <000701c3f4e1$aa8e7e70$c19d87d9@LaptopDellXP> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <402E8AC8.5070609@bluewin.ch> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/17 X-Sequence-Number: 17 >Oli Sennhauser [mailto:oli.sennhauser@bluewin.ch] > Hi Simon > > I do not know if it is already the time to think on standby databases > with "managed recovery" while people have reading access on the database. > It would give a nice HA-Feature. > Please do not forget to have mirrored log files (for security also) for > this feature, localy and also remote. > > I dont know if it is easier to plan this features in advance or later... > > Regards Oli > > ------------------------------------------------------- > > Oli Sennhauser > Database-Engineer (Oracle & PostgreSQL) > Rebenweg 6 > CH - 8610 Uster / Switzerland > (personal contact details removed by SR) > Website http://mypage.bluewin.ch/shinguz/PostgreSQL/ Oli, Thanks very much for your suggestion. I would like to see you suggestion implemented eventually, so will think about this aspect as well. My thoughts are that there is an intermediate step, which is that of a "standby database". I'll update the Proposal into a Design document with this in mind. Best regards Simon