X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A79683A4549 for ; Mon, 15 Nov 2004 16:25:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60372-07 for ; Mon, 15 Nov 2004 16:25:08 +0000 (GMT) Received: from web12705.mail.yahoo.com (web12705.mail.yahoo.com [216.136.173.242]) by svr1.postgresql.org (Postfix) with SMTP id 3B42A3A4520 for ; Mon, 15 Nov 2004 16:25:07 +0000 (GMT) Received: (qmail 10002 invoked by uid 60001); 15 Nov 2004 16:25:06 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=hxKBrnkFCfyIdbQgSwqmCrRxT64lDkYiGnKxlbpwvfi6B4xWi6V5QcXkNhNG3wf0jyZZ/ZqlOxNPoTzOLzMHXP5M1eFahWGGpmxPJzxThHegjUZ/UaXG6XHVjCmUCGIq6h2Qj6GKVex9ZRZC/L8H11HR4zg7kLKscIYESmUlvVE= ; Message-ID: <20041115162505.9994.qmail@web12705.mail.yahoo.com> Received: from [216.194.17.194] by web12705.mail.yahoo.com via HTTP; Mon, 15 Nov 2004 08:25:05 PST Date: Mon, 15 Nov 2004 08:25:05 -0800 (PST) From: Reply-To: ogjunk-pgjedan@yahoo.com Subject: cannot open segment 1 of relation .... No such file or directory To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200411/115 X-Sequence-Number: 15499 Hello, I'm using PG 7.3.4 under RedHat 9.0 and I've started noticing the following type of errors: cannot open segment 1 of relation url (target block 537329664): No such file or directory How can I determine what exactly is corrupt or missing and which row is triggering this? I have found pgfsck (http://svana.org/kleptog/pgsql/pgfsck.html), but that gives me some funky, unrelated(?) output, like this: -- Detected database format 7.3 -- Scanning table url -- Indexing toast table -- Index complete: 0 toasted tuples -- Table url(17129): *** SERIOUS ***: No definition found for column 1 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 2 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 3 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 4 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 5 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 6 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 7 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 8 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 9 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 10 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 11 -- Table url(17129): Found old version, continuing -- Table url(17129): *** SERIOUS ***: No definition found for column 12 -- Table url(17129): Found old version, continuing -- Table url(17129):Page 0:Tuple 0: Unknown type timestamp (1114) -- Table url(17129):Page 0:Tuple 0: Unknown type timestamp (1114) -- Table url(17129):Page 0:Tuple 1: Unknown type timestamp (1114) -- Table url(17129):Page 0:Tuple 1: Unknown type timestamp (1114) ... ... keeps going through Pages with the same timestamp error ... ... As far as I can tell, the above errors/warnings are not related to the error I am getting. I do have a dump of this DB, in case that can be used to fix the corrupt tuple. I dump this DB every night with: pg_dump -d xxx --clean --inserts --column-inserts --format=P -v Any help would be much appreciated. Thanks, Otis