How to determine which file contains which block

From: Frank Way <fgw_three(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: fgw_three(at)yahoo(dot)com
Subject: How to determine which file contains which block
Date: 2004-01-28 21:37:22
Message-ID: 20040128213722.6828.qmail@web11610.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <grin>.

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White (cjwhite) 2004-01-28 21:48:20 Re: Error seen when vacuuming pg_largeobject table
Previous Message Mark Harrison 2004-01-28 20:00:51 log file: showing disconnects as well as connects?