-----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@crimelabs.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-----