Re: [pgadmin-support] Lost database

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: [pgadmin-support] Lost database
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17C7DE0D@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: [pgadmin-support] Lost database  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
John R Pierce wrote:
> if the postgresql server was running when that file backup was made(*),
> its pretty much worthless, it will have data corruption and errors
> throughout.

Well, it would be better than nothing.
You can pg_resetxlog and manually clean up the inconsistencies.
That's better than nothing at all.

Yours,
Laurenz Albe

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

Предыдущее
От: Spiros Ioannou
Дата:
Сообщение: Re: While only running pg_dump, postgresql performs writes inside base/ directory. How can we stop this?
Следующее
От: Wojciech Skaba
Дата:
Сообщение: Bitmap Heap Scan slowdown