Re: What are these files?

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(dot)Rosenman(at)pervasive(dot)com
Web: www.pervasive.com