Re: BUG #12050: Orphaned base files - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12050: Orphaned base files
Date
Msg-id 13113.1416884961@sss.pgh.pa.us
Whole thread Raw
In response to BUG #12050: Orphaned base files  (jkoceniak@mediamath.com)
Responses Re: BUG #12050: Orphaned base files  (Jamie Koceniak <jkoceniak@mediamath.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: David G Johnston
Date:
Subject: Re: function length(numeric) does not exist
Next
From: Magnus Hagander
Date:
Subject: Re: [PATCH] initdb: Option description.