Обсуждение: data/base file structure

> Chris Ruprecht wrote:
>
> Hi all,
>
> 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
>

In 7.1 and later, there is one database per directory and the
directories
are named $PGDATA/base/<oid>, where <oid> is the oid of the pg_database
entry.

Regards,
Oliver

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