[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #12050: Orphaned base files
From:       Jamie Koceniak <jkoceniak () mediamath ! com>
Date:       2014-11-25 3:39:45
Message-ID: 84CE67AB46ACDA41B18094177DD0853D2C082B () ORD2MBX04C ! mex05 ! mlsrvr ! com
[Download RAW message or body]

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/main/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.  Are there any other system tables I should be looking at? 

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 
> the files still remain under /9.1/main/base/.

There are no (or at least should be no) data files directly under $PGDATA/base --- \
they all live one level further down under a per-database subdirectory.  The fact \
that you haven't addressed that point makes me wonder whether you are checking the \
right database.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[prev in list] [next in list] [prev in thread] [next in thread]