X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E691ED7F2B for ; Tue, 13 Sep 2005 07:52:35 -0300 (ADT) 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 23298-09 for ; Tue, 13 Sep 2005 10:52:29 +0000 (GMT) Received: from mxout.fs-cfc.co.uk (mxout.fs-cfc.co.uk [193.203.83.15]) by svr1.postgresql.org (Postfix) with ESMTP id 4B30AD7201 for ; Tue, 13 Sep 2005 07:52:28 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by mxout.fs-cfc.co.uk (Postfix) with ESMTP id 4AF1C13803A; Tue, 13 Sep 2005 11:52:23 +0100 (BST) Received: from mxout.fs-cfc.co.uk ([127.0.0.1]) by localhost (mx-out [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 20784-08; Tue, 13 Sep 2005 11:52:20 +0100 (BST) Received: from mail.admin.local (mail.admin.local [192.168.2.15]) by mxout.fs-cfc.co.uk (Postfix) with ESMTP id 1452A138024; Tue, 13 Sep 2005 11:51:40 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by mail.admin.local (Postfix) with ESMTP id 69980FA1581; Tue, 13 Sep 2005 11:50:59 +0100 (BST) Received: from [172.17.40.85] (sys385.prod.local [172.17.40.85]) by mail.admin.local (Postfix) with ESMTP id 38886D489E6; Tue, 13 Sep 2005 11:50:58 +0100 (BST) Message-ID: <4326AF11.3060108@framestore-cfc.com> Date: Tue, 13 Sep 2005 11:50:57 +0100 From: Dilipan Sebastiampillai User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: could not locate a valid checkpoint record References: <4321996C.90603@framestore-cfc.com> <10710.1126278473@sss.pgh.pa.us> In-Reply-To: <10710.1126278473@sss.pgh.pa.us> Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.63 required=5 tests=[AWL=-0.630, HTML_30_40=0.056, HTML_MESSAGE=0.001, HTML_TITLE_EMPTY=0.045, MIME_HTML_ONLY=1.158] X-Spam-Level: X-Archive-Number: 200509/129 X-Sequence-Number: 18866 thanks a lot Tom, it worked.

Dilipan


Tom Lane wrote:
Dilipan Sebastiampillai <dilipan.sebastiampillai@framestore-cfc.com> writes:
  
I tried ( after copying thes PGDATA dir obviously ) :
pg_resetxlog /var/lib/pgsql/data/ -f
    

  
After that postgreSQL starts but I realised that pg_database is empty ( 
it contains only template0 and template1 ) .
    

It sounds like pg_resetxlog guessed at an XID counter that is too small
and so all your data rows seem to be "in the future".

You need to find out approximately where the XID counter had been.
You can probably tell this by looking at the pg_clog directory;
read the pg_resetxlog man page for details.  I would suggest paying
close attention to the other settable options for resetxlog, too
--- if it got XID wrong then it likely got the others wrong as well.

Once you get out of this I'd suggest a dump/initdb/restore to make
sure your data is consistent; you may well have more problems than
appear on the surface.

Oh, and updating to the latest release of the 7.4 branch would be
a good idea too ;-).  There are some pretty serious known bugs in
7.4.5.

			regards, tom lane
  


-- 


Dilipan Sebastiampillai
Systems - DBA
Framestore CFC
9 Noel Street
London W1F 8GH
tel : +44(0)20 7106 2907
http://www.framestore-cfc.com/