DB corruption - Mailing list pgsql-performance

From Akshay Ballarpure
Subject DB corruption
Date
Msg-id OF94BA8A8F.1EB42658-ON65258259.002B6813-65258259.002BCA1B@tcs.com
Whole thread Raw
Responses Re: DB corruption
Re: DB corruption
List pgsql-performance
Hi,
I have a query on DB corruption. Is there any way to recover from it without losing data ?

Starting postgresql service: [ OK ]
psql: FATAL: index "pg_authid_rolname_index" contains unexpected zero page at block 0
HINT: Please REINDEX it.
psql: FATAL: "base/11564" is not a valid data directory
DETAIL: File "base/11564/PG_VERSION" does not contain valid data.
HINT: You might need to initdb.
psql: FATAL: "base/11564" is not a valid data directory
DETAIL: File "base/11564/PG_VERSION" does not contain valid data.
HINT: You might need to initdb.
psql: FATAL: "base/11564" is not a valid data directory
DETAIL: File "base/11564/PG_VERSION" does not contain valid data.
HINT: You might need to initdb.
psql: FATAL: "base/11564" is not a valid data directory
DETAIL: File "base/11564/PG_VERSION" does not contain valid data.
HINT: You might need to initdb.


With Best Regards
Akshay

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: badly scaling performance with appending to bytea
Next
From: Michael Paquier
Date:
Subject: Re: DB corruption