Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a database, when I look for some tables in the database it shows error
ERROR: could not read block 84 in file "base/16386/670007": Input/output error
I am using postgresql.
Whenever this error is encountered I have to reload the table again and again. But this is not a permanent solution. How I can resolve this error? I have tried to take backup using pg_dump but its also not working.
Your storage subsystem is failing. This is not a PostgreSQL error, as such, it's an error from the underlying file system or disks.
You might learn more from the output of the dmesg command and/or the kernel logs.
