I/O error on data file, can't run backup

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: I/O error on data file, can't run backup
Date: 2011-10-05 18:13:46
Message-ID: 201110052013.46449.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Running postgresql 9.0.5 on

balapapa ~ # uname -a
Linux balapapa 2.6.39-gentoo-r3 #1 SMP Sun Jul 17 11:22:15 CEST 2011 x86_64
Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz GenuineIntel GNU/Linux

I'm trying to run pg_dump on my database, and get an error:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not read block 1 in file
"base/612249/11658": Inn/ut-feil
pg_dump: The command was: SELECT tableoid, oid, opfname, opfnamespace, (SELECT
rolname FROM pg_catalog.pg_roles WHERE oid = opfowner) AS rolname FROM
pg_opfamily

I have tried to stop postgresql and take a filesystem backup of the data
directory with a cp -ax, but it crashes on the same file. I've looked at the
directory with ls -l, and the file looks pretty normal to me. I've also
rebooted from a live CD and run fsck on my /var partition, and it doesn't find
any problem.

The database is still working perfectly.

The backup script overwrote my previous backup with a 40 byte file (yes silly
me I know that's bloody stupid - I'm gonna fix that) and now I haven't got a
recent backup anymore.

Is this fixable?

regards, Leif

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry Drexler 2011-10-05 18:29:49 Analytic type functionality, matching patters in a column then increment an integer
Previous Message Lauri Kajan 2011-10-05 17:43:58 Re: null values in a view