Re: data/base file structure

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> > can somebody explain to me, or point to an explanation of, the way,
> > PostGreSQL names databases?I have files like 18732 and 7503034 - and
> > they are big but I have no idea which data lives in what file:
> >
> > /home/pgsql/data/base/18720/
> > -rw------- 1 postgres postgres 70385664 May 24 13:55 7503034
> > -rw------- 1 postgres postgres 10788864 May 24 13:54 8748869
> > -rw------- 1 postgres postgres 458752 May 24 12:21 8939786
> > -rw------- 1 postgres postgres 158334976 May 24 13:51 8945104

Take a look at the oid2name tool (contrib/oid2name). It should be able to
decode the file numbers to point to table names for you.

- - Brandon

- ----------------------------------------------------------------------------
b. palmer, bpalmer(at)crimelabs(dot)net pgp:crimelabs.net/bpalmer.pgp5

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
Charset: noconv

iQA/AwUBOxw45/YgmKoG+YbuEQIvRgCg/bHVc/m16kRHcEvC0JKkmhP1Zr0An2QF
lHtY/lwlTpNNa4eF9NqJ0mDX
=9Y3u
-----END PGP SIGNATURE-----