Help me recovering data

Поиск
Список
Период
Сортировка
От Kouber Saparev
Тема Help me recovering data
Дата
Msg-id 001601c51289$671276d0$8100030a@pdc.imro.bg
обсуждение исходный текст
Ответы Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Dealing with network-dead clients
Следующее
От: Sibtay Abbas
Дата:
Сообщение: Re: getting oid of function