Hi Tom,
I haven't heard anything back on this issue for some time.
Is it safe to remove the files /postgresql/9.1/main/base/31858 directory?
Thanks,
Jamie
-----Original Message-----
From: Jamie Koceniak=20
Sent: Monday, November 24, 2014 7:40 PM
To: 'Tom Lane'
Cc: pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #12050: Orphaned base files
Hi Tom,
We only have one database and all the orphaned files are located under:
/postgresql/9.1/main/base/31858
It looks like we have over 100G of orphaned files in the /postgresql/9.1/ma=
in/base/31858 directory.
For example, I am unable to locate 2600102740 in the master pg_class system=
table but these files exist in the data directory.=20
Are there any other system tables I should be looking at?=20
Example orphaned files:
-rw------- 1 postgres postgres 1073741824 Nov 10 14:56 2600102740
-rw------- 1 postgres postgres 1073741824 Nov 10 14:56 2600102740.1
-rw------- 1 postgres postgres 1073741824 Nov 10 15:06 2600102740.10
-rw------- 1 postgres postgres 116482048 Nov 10 15:06 2600102740.11
-rw------- 1 postgres postgres 1073741824 Nov 10 14:56 2600102740.2
-rw------- 1 postgres postgres 1073741824 Nov 10 14:56 2600102740.3
-rw------- 1 postgres postgres 1073741824 Nov 10 14:57 2600102740.4
-rw------- 1 postgres postgres 1073741824 Nov 10 14:57 2600102740.5
-rw------- 1 postgres postgres 1073741824 Nov 10 14:57 2600102740.6
-rw------- 1 postgres postgres 1073741824 Nov 10 14:57 2600102740.7
-rw------- 1 postgres postgres 1073741824 Nov 10 15:03 2600102740.8
-rw------- 1 postgres postgres 1073741824 Nov 10 15:04 2600102740.9
-rw------- 1 postgres postgres 2949120 Nov 10 13:27 2600102740_fsm
What is the process for cleaning up files in a data directory when you can'=
t locate the tables in the system tables like pg_class?
Thanks!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, November 24, 2014 7:09 PM
To: Jamie Koceniak
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #12050: Orphaned base files
jkoceniak@mediamath.com writes:
> I have identified a number of tables that were dropped in the db but=20
> the files still remain under /9.1/main/base/.
There are no (or at least should be no) data files directly under $PGDATA/b=
ase --- they all live one level further down under a per-database subdirect=
ory. The fact that you haven't addressed that point makes me wonder whethe=
r you are checking the right database.
regards, tom lane