Обсуждение: What are these files?

I have some file in my database directories that I can not find an purpose to.

What I have been doing is trying to relate each file in my <db path>/base/<oid>/  to the actual name (ie tablea, indexb, etc...), and I have ran into files that are not in the pg_class table.  I am not sure where else to look for the purpose of these files.  Can anyone give me some suggestions?  Files appear to be oids in name, and some of them are split into multiple files (i.e.2109357800, 2109357800.1, 2109357800.2, 2109357800.3, 2109357800.4).

Thanks for any help,

Chris

PG 7.3.4

Chris Hoover wrote:
> I have some file in my database directories that I can not find an
> purpose to.
>
> What I have been doing is trying to relate each file in my <db
> path>/base/<oid>/  to the actual name (ie tablea, indexb, etc...),
> and I have ran into files that are not in the pg_class table.  I am
> not sure where else to look for the purpose of these files.  Can
> anyone give me some suggestions?  Files appear to be oids in name,
> and some of them are split into multiple files (i.e.2109357800,
> 2109357800.1, 2109357800.2, 2109357800.3, 2109357800.4).
>
> Thanks for any help,
>
> Chris
>
> PG 7.3.4

 contrib/oid2name is what you need.
--
Larry Rosenman
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX  78727-6531

Tel: 512.231.6173
Fax: 512.459.1309
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com

Chris Hoover <revoohc@gmail.com> writes:
> I have some file in my database directories that I can not find an purpose
> to.

Read http://www.postgresql.org/docs/8.0/static/storage.html

Some of this doesn't apply to PG 7.3, but most of it does.  In
particular I suspect you are confused about oid vs relfilenode.

            regards, tom lane