X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D5A1E9DC827 for ; Wed, 4 Jan 2006 13:23:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58375-07 for ; Wed, 4 Jan 2006 13:23:13 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196]) by postgresql.org (Postfix) with ESMTP id 771899DC802 for ; Wed, 4 Jan 2006 13:23:12 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so1860213wxc for ; Wed, 04 Jan 2006 09:23:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=fT8Zl7dddiYMJZdL+odlYl4gFVpVvQWZVxiNgUYbWrZyHcF7VMftDJpDXa0FkWgyGHOBFi8F0cxjtt0uyVy5jaFkZPiyCeXhGTCxiKwWd5RdELQmOGgFOcBlbC9oJJpn75zvJLYyG7ERqmJ1HRL1h+8Hm71jZxq9LgZJx8096n4= Received: by 10.70.38.19 with SMTP id l19mr646385wxl; Wed, 04 Jan 2006 09:23:12 -0800 (PST) Received: by 10.70.84.7 with HTTP; Wed, 4 Jan 2006 09:23:12 -0800 (PST) Message-ID: <1d219a6f0601040923m19f8bfd6x517cd3c33336d21d@mail.gmail.com> Date: Wed, 4 Jan 2006 12:23:12 -0500 From: Chris Hoover To: "pgsql-admin@postgresql.org" Subject: What are these files? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_32613_3661071.1136395392054" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.528 required=5 tests=[AWL=-0.418, HTML_10_20=0.945, HTML_MESSAGE=0.001] X-Spam-Score: 0.528 X-Spam-Level: X-Archive-Number: 200601/51 X-Sequence-Number: 20139 ------=_Part_32613_3661071.1136395392054 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 /base// 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 wher= e 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 ------=_Part_32613_3661071.1136395392054 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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

------=_Part_32613_3661071.1136395392054--