On 18 June 2010 17:27, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Andy Dale <andy.dale@xxxxxxxxx> 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).
