pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat 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