X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45FDA3A1AFF for ; Mon, 20 Dec 2004 02:33:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49772-09 for ; Mon, 20 Dec 2004 02:33:39 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E56F93A1ACB for ; Mon, 20 Dec 2004 02:33:42 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iBK2XeUp009258; Sun, 19 Dec 2004 21:33:41 -0500 (EST) To: Alvaro Herrera Cc: harry@uklug.co.uk, pgsql-docs@postgresql.org Subject: Re: Database Recovery In-reply-to: <20041220004132.GA8996@dcc.uchile.cl> References: <20041220001118.87459.qmail@web50403.mail.yahoo.com> <20041220004132.GA8996@dcc.uchile.cl> Comments: In-reply-to Alvaro Herrera message dated "Sun, 19 Dec 2004 21:41:32 -0300" Date: Sun, 19 Dec 2004 21:33:40 -0500 Message-ID: <9257.1103510020@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/36 X-Sequence-Number: 2732 Alvaro Herrera writes: > On Sun, Dec 19, 2004 at 04:11:17PM -0800, Harry wrote: >> http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html > Huh, this sounds like transaction Id wraparound to me. Given the mention of a drive glitch, I'm mentally comparing it to our present theory about Joe Conway's recent troubles. That is, I wonder if he had a mistakenly-reinitialized pg_control. Harry, are you using a Postgres start script that will automatically run initdb if it doesn't see a valid data directory at $PGDATA? regards, tom lane