pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
What are these files?
3+ messages / 3 participants
[nested] [flat]

* What are these files?
@ 2006-01-04 17:23 Chris Hoover <revoohc@gmail.com>
  2006-01-04 17:46 ` Re: What are these files? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Chris Hoover @ 2006-01-04 17:23 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: What are these files?
  2006-01-04 17:23 What are these files? Chris Hoover <revoohc@gmail.com>
@ 2006-01-04 17:46 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2006-01-04 17:46 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: What are these files?
@ 2006-01-04 17:31 Larry Rosenman <lrosenman@pervasive.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Larry Rosenman @ 2006-01-04 17:31 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; pgsql-admin

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 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-01-04 17:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-04 17:23 What are these files? Chris Hoover <revoohc@gmail.com>
2006-01-04 17:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-01-04 17:31 Re: What are these files? Larry Rosenman <lrosenman@pervasive.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox