| From: | "Kouber Saparev" <postgresql(at)saparev(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Help me recovering data |
| Date: | 2005-02-14 11:36:19 |
| Message-ID: | 001601c51289$671276d0$8100030a@pdc.imro.bg |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)irc(dot)freenode(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sibtay Abbas | 2005-02-14 12:02:19 | Re: getting oid of function |
| Previous Message | Oliver Jowett | 2005-02-14 10:52:59 | Re: Dealing with network-dead clients |