Re: Remove sort files

> Peter Eisentraut <peter_e@gmx.net> writes:
> > Why don't we put the sort files into /tmp and let the system figure out
> > how to get rid of them?
>
> Hard-wiring the assumption that they should be in /tmp would be VASTLY
> worse than our current situation.  Lots of people run with /tmp its own,
> not very large partition.  There are also serious security issues on
> machines that don't have directory stickybits.
>
> I do not like the way Bruce is doing the find, either, but moving stuff
> to /tmp isn't the answer.
>
> One reasonable idea is
>
>     cd pg_sorttemp ; rm -f *
>
> which could potentially fail if there are LOTS of dead temp files
> (enough to make the expanded rm command overrun your kernel limit on
> command length) but if there are that many then you've got serious
> problems anyway.

OK, here is the new 'find' line:

"find \"%s\"/base -name pg_sorttemp ! -type f -exec /bin/sh -c \"cd {}; rm -f *\" \\;",
               

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026