If someone happened to accidentally end up with a lot of files that were NOT part of their database in the data/base/XXXXX directory, how could they go about getting a reliable list of files they could safely delete? The files were there before the current incarnation of the database, so have ctime before the good ones, but may be valid because they were updated by rsync, but I don't know that mtime is reliable for every file either, since some may have been unchanged from the first time this someone ran rsync.
Not a super big deal, just wasting a lot of space... Thanks! Ian postgresql 9.0.4 on linux -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
