I use psql (PostgreSQL) 9.2.2 postgresql-9.2-1002.jdbc4.jar java version "1.7.0_17" 64-Bit Server VM
on Linux 3.4.28-2.20-default
with SSD Intel 520 Series SSDs smartctl -a /dev/sdc1 does not show me errors (afaik)
and get this error: org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420
I believe it is a kernel or HD problem and my idea was to dump the data and install it on another HD:
pg_dump custdb > custdb-2013-03-18.dump pg_dump: Dumping the contents of table "location" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: invalid page header in block 5869177 of relation base/17291/17420 pg_dump: The command was: COPY public.location (xxx) TO stdout;
I looks like that the dump stops. What can I do to convince the dump to continue? After migrating to another HD I could try to reimport lost data from log files etc.
What is the reason for this error? What options do I have?