Re: - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re:
Date
Msg-id 20041019154153.GF3359@phlogiston.dyndns.org
Whole thread Raw
In response to  ("Ben Osborne" <bosborne@bsdmarketing.co.uk>)
Responses Re:
List pgsql-hackers
On Tue, Oct 19, 2004 at 01:28:52PM +0100, Ben Osborne wrote:
> Postgres 7.0.2 Problem
> -----------------------------------

Yikes.  That's old. 

> (only) database which is running (other than template1).  I suspect that the
> files in the data directory have been conrrupted or otherwise lost
> integrity, possibly due to the fact that the disk partition where the db
> cluster is running has reached 100% usage.
>  
> The problem is the -l doesn't list my database in the catalog, although i
> can psql xxxxx into the database.  Further, \d lists 'No Relations', however
> i can select * from a table, and although the database reports no rows, the
> table scheme does report correctly. 

I doubt that's your problem.  I suspect xid wraparound instead. 
Unfortunately, without a pg_dump, I suspect your data is
inaccessible  (see the current docs, section 21.1.3, for an
explanation of why this is.  I think the 7.0 docs don't contain all
that info, BTW).  We have a very dangerous tool we've used for testing
that will thump the xid in 7.2, but I have no idea whether that'd
work in versions prior to that.  Jan Wieck might know, though.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: gettext calls in pgport
Next
From: Tom Lane
Date:
Subject: Re: spinlocks: generalizing "non-locking test"