Database Recovery

Поиск
Список
Период
Сортировка
От Jean-Arthur Silve
Тема Database Recovery
Дата
Msg-id 4.3.0.20010213100806.03681e20@mail.eurovox.fr
обсуждение исходный текст
Список pgsql-general
Hi !

I have a big problem : all my datas are unavailable.
When I do a vaccuum, that ok there are rows.

When I do a "SELECT" or "\d", nothing.

One of you told me that could be that I reached the max transaction ID.
My pg_log is very big (1 Go !!)

How could I retrieve my datas ?

Of course I tried pg_dump : nothing !

Fils is the DB sub directories seems ok...

I tried to make a new install, I re create all the DB, than moved my
datafiles to each subdirectories.
But nothing !
Then I moved to the old pg_log file to the new DB ! Nothing !

Is there a way to retrieve my datas, even without the indexes ???

thank you !

jean-arthur

----------------------------------------------------------------
Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.


В списке pgsql-general по дате отправления:

Предыдущее
От: DaVinci
Дата:
Сообщение: Re: transaction safety
Следующее
От: martin.chantler@convergys.com
Дата:
Сообщение: Re: Re: numeric type and odbc from access 2000