RE: [ADMIN] pg_sorttemp files

2000-05-03 Thread Nicolas Huillard
the involved queries, thus died without erasing the files. Nicolas Huillard -Message d'origine- De: brianb [SMTP:[EMAIL PROTECTED]] Date: mercredi 3 mai 2000 11:56 À: Nicolas Huillard Cc: [EMAIL PROTECTED] Objet: Re: [ADMIN] pg_sorttemp files Ok, thanks. But wh

Re: [ADMIN] pg_sorttemp files

2000-05-03 Thread Peter Eisentraut
On Wed, 3 May 2000, brianb wrote: > Ok, thanks. But why are they there in the first place, then? A backend crash during sorting -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] pg_sorttemp files

2000-05-03 Thread brianb
Ok, thanks. But why are they there in the first place, then? Nicolas Huillard writes: > As soon as every postgres back-end server if closed, it is safe to delete these >files. > I do a... > ps axf | grep -e "[P]ID" -e "[p]ost" > ... to check for living back-ends... > > Nicolas Huillard > > -

RE: [ADMIN] pg_sorttemp files

2000-05-03 Thread Nicolas Huillard
As soon as every postgres back-end server if closed, it is safe to delete these files. I do a... ps axf | grep -e "[P]ID" -e "[p]ost" ... to check for living back-ends... Nicolas Huillard -Message d'origine- De: brianb [SMTP:[EMAIL PROTECTED]] Date: mercredi 3 mai 2000 04:32 À: