Re: is it possible to delete the psql log while psql is - Mailing list pgsql-general

From Thies C. Arntzen
Subject Re: is it possible to delete the psql log while psql is
Date
Msg-id A12BB711-8D35-46F2-809F-71A276B920B7@thieso.net
Whole thread Raw
In response to Re: is it possible to delete the psql log while psql is  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
hi,

use  "cp /dev/null pqsql.log" to truncate the logfile "in place" and
free some space.

re, thies

Am 08.12.2005 um 23:26 schrieb Ed L.:

> On Thursday December 8 2005 9:19 am, Oleg Bartunov wrote:
>> I'd do
>> echo > pgql.log
>
> That won't free any space from an open file.  You have to stop
> postgresql first in order to close the file, or use log file
> rotation and wait until it rotates out to a closed state.

pgsql-general by date:

Previous
From: Kathy Lo
Date:
Subject: Re: memory leak under heavy load?
Next
From: gabor
Date:
Subject: after vacuum, db is still "growing" :(