Postgres Pro
Downloads
Home   >   mailing lists

multiple tables got corrupted - Mailing list pgsql-general

From Vasu Madhineni
Subject multiple tables got corrupted
Date
Msg-id CAFacQoEyobPXSfSf_vLMOnjDob2ROw7rpNSHmfTv0DE_MKtZzg@mail.gmail.com
Whole thread Raw
Responses Re: multiple tables got corrupted
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?
Next
From: Magnus Hagander
Date:
Subject: Re: multiple tables got corrupted