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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
