From: Dilipan Sebastiampillai <dilipan.sebastiampillai@framestore-cfc.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: could not locate a valid checkpoint record
Date: Tue, 13 Sep 2005 11:50:57 +0100
Message-ID: <4326AF11.3060108@framestore-cfc.com> (raw)
In-Reply-To: <10710.1126278473@sss.pgh.pa.us>
References: <4321996C.90603@framestore-cfc.com>
<10710.1126278473@sss.pgh.pa.us>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
thanks a lot Tom, it worked.<br>
<br>
Dilipan<br>
<br>
<br>
Tom Lane wrote:
<blockquote cite="mid10710.1126278473@sss.pgh.pa.us" type="cite">
<pre wrap="">Dilipan Sebastiampillai <a class="moz-txt-link-rfc2396E" href="mailto:dilipan.sebastiampillai@framestore-cfc.com"><dilipan.sebastiampillai@framestore-cfc.com></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">I tried ( after copying thes PGDATA dir obviously ) :
pg_resetxlog /var/lib/pgsql/data/ -f
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<pre wrap="">After that postgreSQL starts but I realised that pg_database is empty (
it contains only template0 and template1 ) .
</pre>
</blockquote>
<pre wrap=""><!---->
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
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Dilipan Sebastiampillai
Systems - DBA
Framestore CFC
9 Noel Street
London W1F 8GH
tel : +44(0)20 7106 2907
<a class="moz-txt-link-freetext" href="http://www.framestore-cfc.com/">http://www.framestore-cfc.com/</a;
</pre>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: dilipan.sebastiampillai@framestore-cfc.com, tgl@sss.pgh.pa.us
Subject: Re: could not locate a valid checkpoint record
In-Reply-To: <4326AF11.3060108@framestore-cfc.com>
References: <4321996C.90603@framestore-cfc.com> <10710.1126278473@sss.pgh.pa.us> <4326AF11.3060108@framestore-cfc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox