X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0C1E1D1B95A for ; Wed, 28 Jan 2004 21:37:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14851-01 for ; Wed, 28 Jan 2004 17:37:23 -0400 (AST) Received: from web11610.mail.yahoo.com (web11610.mail.yahoo.com [216.136.129.39]) by svr1.postgresql.org (Postfix) with SMTP id CF60CD1BB89 for ; Wed, 28 Jan 2004 17:37:20 -0400 (AST) Message-ID: <20040128213722.6828.qmail@web11610.mail.yahoo.com> Received: from [206.105.19.34] by web11610.mail.yahoo.com via HTTP; Wed, 28 Jan 2004 13:37:22 PST Date: Wed, 28 Jan 2004 13:37:22 -0800 (PST) From: Frank Way Subject: How to determine which file contains which block To: pgsql-admin@postgresql.org Cc: fgw_three@yahoo.com MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/259 X-Sequence-Number: 12122 Hi all, I've recently had the opportunity to use pg_filedump to try and find some corruption in one of my database tables (7.3.4). If found the following description of how to find the block/tuple and to use pg_filedump: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=20030922162322.E12708%40quartz.newn.cam.ac.uk&rnum=8&prev=/groups%3Fq%3Dpg_filedump%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3D20030922162322.E12708%2540quartz.newn.cam.ac.uk%26rnum%3D8 It was quite good but left one gap that I've not been able to figure out. After finding the ctid in (block,tuple) format, how do you know which file in all the subdirectories under /usr/local/pgsql/data/base contains that block? I'm a bit ashamed to say I found it through trial and error. There has to be a better way . I've looked through the documentation, but haven't found anything on this subject. Thanks for your help, Frank Way __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/