| From: | Ian Harding <harding(dot)ian(at)gmail(dot)com> |
|---|---|
| To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Extraneous Files |
| Date: | 2011-10-20 17:12:38 |
| Message-ID: | CAMR4UwGDQVpqp8eo7WvxuXK6OTX2t7BmB3PCDtSwAnHdYkNi7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martín Marqués | 2011-10-20 17:13:32 | Re: inserting bytea using PHPs pg_escape_bytea() |
| Previous Message | Jeff Davis | 2011-10-20 17:08:45 | Re: timeline X of the primary does not match recovery target timeline Y |