X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 59D66D1C517 for ; Tue, 18 Nov 2003 18:40:22 +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 85650-06 for ; Tue, 18 Nov 2003 14:39:52 -0400 (AST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by svr1.postgresql.org (Postfix) with ESMTP id EEB69D1C916 for ; Tue, 18 Nov 2003 14:39:50 -0400 (AST) Received: from lhosts ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031118183947.PYFQ2192.lakemtao03.cox.net@lhosts> for ; Tue, 18 Nov 2003 13:39:47 -0500 Subject: Re: Point-in-time data recovery - v.7.4 From: Ron Johnson To: PgSQL General ML In-Reply-To: <20031118142919.GI4953@libertyrms.info> References: <1069164075.986.239.camel@bbking.uio.no> <20031118142919.GI4953@libertyrms.info> Content-Type: text/plain Message-Id: <1069180780.2769.91.camel@haggis.homelan> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 18 Nov 2003 12:39:40 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/932 X-Sequence-Number: 52582 On Tue, 2003-11-18 at 08:29, Andrew Sullivan wrote: > On Tue, Nov 18, 2003 at 03:01:15PM +0100, Rafael Martinez Guerrero wrote: > > References in mailinglists talk about version 7.4 and in the TODO list > > is under the section 'urgent'. > > It didn't get done. > > > Anybody knows when this functionality will be available with > > prod-quality? > > I don't think so. > > Jan Wieck has a proposal for a new replication system which will > offer a trick for producing point in time as a side benefit. We are > aiming to have that software in use sooner rather than later, but it > hasn't been written yet. Supplanting PITR with Replication? If so, I don't think that's a good idea, since you'd either have to buy a new server, or double disk capacity, both of which can cost noticeable amounts of money, if SCSI disks are used. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA When Swedes start committing terrorism, I'll become suspicious of Scandinavians.