Re: BUG #12050: Orphaned base files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jkoceniak(at)mediamath(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12050: Orphaned base files
Date: 2014-11-25 03:09:21
Message-ID: 13113.1416884961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jkoceniak(at)mediamath(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jamie Koceniak 2014-11-25 03:39:45 Re: BUG #12050: Orphaned base files
Previous Message David G Johnston 2014-11-25 00:17:07 Re: function length(numeric) does not exist