Help me recovering data - Mailing list pgsql-hackers

From Kouber Saparev
Subject Help me recovering data
Date
Msg-id 001601c51289$671276d0$8100030a@pdc.imro.bg
Whole thread Raw
Responses Re: Help me recovering data
List pgsql-hackers
Hi folks,

I ran into big trouble - it seems that my DB is lost.

"select * from pg_database" gives me 0 rows, but I still can connect to
databases with \c and even select from tables there, although they're also
not visible with \dt.

After asking the guys in the #postgresql@irc.freenode.net channel they told
me that the reason is the "Transaction ID wraparound", because I have never
ran VACUUM on the whole database.

So they proposed to ask here for help. I have stopped the server, but what
could I do in order to save the data if it's possible at all?

You could also take a look at my pg_controldata output:
http://rafb.net/paste/results/ghcIb880.html

Regards,
Kouber Saparev



pgsql-hackers by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Dealing with network-dead clients
Next
From: Sibtay Abbas
Date:
Subject: Re: getting oid of function