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

From Csaba Nagy
Subject Re: is it possible to delete the psql log while psql is
Date
Msg-id 1134050969.4779.263.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: is it possible to delete the psql log while psql is  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
[snip]
> Note: on Linux I've had success with simply truncating the file using:
>
> : > [filename]
>
> This does free up the space used straightaway. Depending on the mode
> the file was opened with it may also reset the position the postmaster
> writes at.

Interesting hint, I'll try it next time I'll need such effect, although
I won't do it with any production data base ;-)

Thanks Martijn !

Cheers,
Csaba.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: is it possible to delete the psql log while psql is
Next
From: gabor
Date:
Subject: is it possible to delete the psql log while psql is running?