On 18 June 2010 17:27, Tom Lane <t...@sss.pgh.pa.us> wrote: > Andy Dale <andy.d...@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).