3

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.

Ian_H
1,67410 silver badges17 bronze badges
asked Mar 7, 2017 at 10:55
1
  • Have you tried moving the DB to other hardware or just change the disk(s)? Commented Mar 7, 2017 at 13:16

1 Answer 1

4

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.

answered Mar 8, 2017 at 0:34

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.