Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 75BB247730F for ; Fri, 24 Jan 2003 11:07:55 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id A1C224758FE for ; Fri, 24 Jan 2003 10:48:29 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18c64I-0001GX-00 for ; Fri, 24 Jan 2003 10:48:34 -0500 Date: Fri, 24 Jan 2003 10:48:34 -0500 From: Andrew Sullivan To: PgSQL Performance ML Subject: Re: Crash Recovery, pt 2 Message-ID: <20030124104834.B32645@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , PgSQL Performance ML References: <2147483647.1043361178@[10.0.1.133]> <20030124082219.B26558@mail.libertyrms.com> <1043417539.29437.82.camel@haggis> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1043417539.29437.82.camel@haggis>; from ron.l.johnson@cox.net on Fri, Jan 24, 2003 at 08:12:19AM -0600 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/282 X-Sequence-Number: 929 On Fri, Jan 24, 2003 at 08:12:19AM -0600, Ron Johnson wrote: > On commercial databases, there's a command to flush the roll-forward > logs to tape at intervals during the day. [. . .] > Are there any FM's that explain how this works in Postgres? Not yet, because you can't do it. There is, I understand, some code currently being included in 7.4 to do this. So that's when it'll happen. Look for "point in time recovery" or "PITR" on the -hackers list to see the progress. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110