Re: Unable to determine what has a particular OID - Mailing list pgsql-general

From Andy Dale
Subject Re: Unable to determine what has a particular OID
Date
Msg-id AANLkTikaHt1k9WTac6t-YhVlKZbVjZk0nHpFpXvZIVLl@mail.gmail.com
Whole thread Raw
In response to Re: Unable to determine what has a particular OID  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unable to determine what has a particular OID  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
On 18 June 2010 17:27, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andy Dale <andy.dale@gmail.com> writes:
> OK, I have just run the query, and both are in the same database.

OK.  Given the narrow range of timestamps on the files, the most
likely bet here is that you're looking at the leftovers from a
"CREATE TABLE AS" or similar command that failed partway through and
for some reason didn't clean up the files it'd created.  As I mentioned,
this'd be unsurprising if there'd been a database crash or kill -9
or something similar involved.  Anyway I think you've done enough to
establish that "rm'ing" those files will be safe.  (But if you're
paranoid you might want to save them someplace first.)

                       regards, tom lane

Thanks for confirming this, I will however save/backup the files before removing them (just in case anything goes wrong).

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to determine what has a particular OID
Next
From: Felde Norbert
Date:
Subject: Re: postgres crash SOS