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/
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? |