From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Schenzel <inittab@unixdev.net>
cc: pgsql-admin@postgresql.org
Subject: Re: Mapping a Data File Back to a Table
In-reply-to: <20130104180933.GA21370@graphite.accessaxis.com>
References: <20130104180933.GA21370@graphite.accessaxis.com>
Comments: In-reply-to Greg Schenzel <inittab@unixdev.net>
	message dated "Fri, 04 Jan 2013 11:09:33 -0700"
Date: Mon, 07 Jan 2013 11:01:54 -0500
Message-ID: <10901.1357574514@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Greg Schenzel <inittab@unixdev.net> writes:
> So I've been digging through a database on an embedded device for two
> days trying to figure out which table some data is stored in. There
> are litterally 1000 tables in the database and I haven't come across
> the right one(s) yet. I know that the data I'm looking for is stored
> in /var/lib/pgsql/data/base/16384/2613 from strings and grep. Is there
> any way to map this back to a table or group of tables? Any insight
> would be greatly appreciated!

Just for the record, the 16384 is the OID of a database (look at
pg_database.oid) and 2613 is the filenode of a table (look at
pg_class.relfilenode in the relevant database).  contrib/oid2name
can help mechanize this but personally I never bother with that.

See http://www.postgresql.org/docs/9.2/static/storage.html
for the authoritative skinny (but note this stuff does change
across releases, so be sure to read the correct version of the docs).

			regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin