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: [EMAIL PROTECTED] Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
