Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0C5259FB1BA for ; Tue, 10 Jul 2007 12:38:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34791-05 for ; Tue, 10 Jul 2007 12:38:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 712509FA9BD for ; Tue, 10 Jul 2007 12:38:30 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6AFcT8M020230; Tue, 10 Jul 2007 11:38:29 -0400 (EDT) To: Juliann Meyer cc: pgsql-admin@postgresql.org Subject: Re: vacuumdb problem v7.4.8 In-reply-to: <469391AD.3030206@noaa.gov> References: <469391AD.3030206@noaa.gov> Comments: In-reply-to Juliann Meyer message dated "Tue, 10 Jul 2007 09:03:25 -0500" Date: Tue, 10 Jul 2007 11:38:29 -0400 Message-ID: <20229.1184081909@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/86 X-Sequence-Number: 26067 Juliann Meyer writes: > vacuumdb: vacuuming of database "adb_ob72orn" failed: ERROR: could not > read block 18658 of relation "pecrsep_time_ind": Input/output error This says read() failed with errno EIO, ie the operating system reported a hardware failure while trying to read that disk block. > The Elec. Technicians at first thought it was an issue with one of the > hard drives, but a very thorough check of the hardware has eliminated > this possibility. Not thorough enough I would say, because there is no other cause of that error code than hardware problems. You do know that PG 7.4.8 is nine minor releases behind the times? That's not the cause of your immediate problem, but personally I'd suggest an update before some other bug bites you. See http://developer.postgresql.org/pgdocs/postgres/release.html regards, tom lane