Reg: PostgreSQL Server "base/data" recovery

From: Prajilal KP <prajilal(dot)kp(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Reg: PostgreSQL Server "base/data" recovery
Date: 2015-03-19 08:19:43
Message-ID: CABsTp+AmS8FhQpXOX-==O-5cc_Qv0_CK8tfsJaRvg_YTT01Jog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2015-03-19 08:46:15 Re: Reg: PostgreSQL Server "base/data" recovery
Previous Message Michael Paquier 2015-03-19 07:31:23 Re: Unicode license compatibility with PostgreSQL license