X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A8DCD6EB0 for ; Wed, 7 Sep 2005 12:44:02 -0300 (ADT) 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 61379-04 for ; Wed, 7 Sep 2005 15:43:57 +0000 (GMT) Received: from mailhub1.sghms.ac.uk (mailhub1.sghms.ac.uk [194.82.51.7]) by svr1.postgresql.org (Postfix) with ESMTP id A60D9D6E15 for ; Wed, 7 Sep 2005 12:43:56 -0300 (ADT) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.24) id 1ED25J-0007c4-Pt; Wed, 07 Sep 2005 16:43:37 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.2 HotFix 2.06 (built Mar 28 2005)) with ESMTPA id <0IMG001M5ECPZP@imail.sghms.ac.uk>; Wed, 07 Sep 2005 16:43:37 +0100 (BST) Date: Wed, 07 Sep 2005 16:40:22 +0100 From: Adam Witney Subject: Re: pg_dump error In-reply-to: <27550.1126106924@sss.pgh.pa.us> To: Tom Lane Cc: pgsql-admin Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT User-Agent: Microsoft-Entourage/10.1.1.2418 X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH1: No virueses detected X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-2.3, required 5, autolearn=not spam, ALL_TRUSTED -3.30, MY_OBFUX 0.50, MY_OBFU_MISC 0.50) X-MailScanner-From: awitney@sgul.ac.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 required=5 tests=[AWL=0.014] X-Spam-Level: X-Archive-Number: 200509/61 X-Sequence-Number: 18798 On 7/9/05 4:28 pm, "Tom Lane" wrote: > Adam Witney writes: >>> I would be interested to see "pg_filedump -i -f" output for the toast >>> table's index before you blow it away, if you have time for that. > >> Yep I can run this.... Can't seem to locate pg_filedump though... Its not in >> contrib... Anyone know where it is these days? > > Same place it's been for awhile: > http://sources.redhat.com/rhdb/ Got that now.... Sorry but I am being dim... But where do I find the file to dump.. You want the index on pg_toast_134401982 right? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.