Reg: PostgreSQL Server "base/data" recovery

Поиск
Список
Период
Сортировка
От Prajilal KP
Тема Reg: PostgreSQL Server "base/data" recovery
Дата
Msg-id CABsTp+AmS8FhQpXOX-==O-5cc_Qv0_CK8tfsJaRvg_YTT01Jog@mail.gmail.com
обсуждение исходный текст
Ответы Re: Reg: PostgreSQL Server "base/data" recovery  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
Hi all,

Thank you for reading this mail. I need your help to fix the issue with my PostgreSQL server.

Recently i have noticed that my PostgreSQL server is returning the error messages like “Could not read block 6160722 in file “base/data/16384/11033028.47”. 
When i have checked the "base/data/16384" directory, some of the file's data size is zero and exactly from that time i have started receiving the said error messages.

Could you please advise the way to recover the Database without loosing any data?

PostgreSQL version : 9.0.4
OS : RHEL 5.5

regards,
prajilal

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Unicode license compatibility with PostgreSQL license
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Reg: PostgreSQL Server "base/data" recovery