DB corruption

Поиск
Список
Период
Сортировка
От Akshay Ballarpure
Тема DB corruption
Дата
Msg-id OF94BA8A8F.1EB42658-ON65258259.002B6813-65258259.002BCA1B@tcs.com
обсуждение исходный текст
Ответы Re: DB corruption  (Michael Paquier <michael@paquier.xyz>)
Re: DB corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: badly scaling performance with appending to bytea
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: DB corruption