multiple tables got corrupted

Поиск
Список
Период
Сортировка
От Vasu Madhineni
Тема multiple tables got corrupted
Дата
Msg-id CAFacQoEyobPXSfSf_vLMOnjDob2ROw7rpNSHmfTv0DE_MKtZzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: multiple tables got corrupted  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
Дерево обсуждения
Hi All,

In one of my postgres databases multiple tables got corrupted and followed the below steps but still the same error.

1.SET zero_damaged_pages = on
2. VACUUM ANALYZE, VACUUM FULL
but still same error. 

moh_fa=# VACUUM FULL;
ERROR:  could not read block 9350 in file "base/1156523/1270812": Input/output error

Tried to take backup of tables with pg_dump but same error. files exist physically in base location.

How to proceed on this, no backup to restore.

Thanks in advance

Regards,
Vasu Madhineni

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: multiple tables got corrupted