pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Way <fgw_three@yahoo.com>
To: pgsql-admin@postgresql.org
Cc: fgw_three@yahoo.com
Subject: How to determine which file contains which block
Date: Wed, 28 Jan 2004 13:37:22 -0800 (PST)
Message-ID: <20040128213722.6828.qmail@web11610.mail.yahoo.com> (raw)

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%40quart...

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/



view thread (3+ messages)  latest in thread

Message-ID: <20040128213722.6828.qmail@web11610.mail.yahoo.com>
Permalink:  ../20040128213722.6828.qmail@web11610.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040128213722.6828.qmail@web11610.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: fgw_three@yahoo.com
  Subject: Re: How to determine which file contains which block
  In-Reply-To: <20040128213722.6828.qmail@web11610.mail.yahoo.com>
  References: <20040128213722.6828.qmail@web11610.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox