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