DB corruption

From: Akshay Ballarpure <akshay(dot)ballarpure(at)tcs(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: DB corruption
Date: 2018-03-23 07:59:35
Message-ID: OF94BA8A8F.1EB42658-ON65258259.002B6813-65258259.002BCA1B@tcs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2018-03-23 08:04:55 Re: DB corruption
Previous Message Pavel Stehule 2018-03-21 13:09:27 Re: badly scaling performance with appending to bytea