Re: is it possible to delete the psql log while psql is

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Gábor Farkas <gabor(at)nekomancer(dot)net>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: is it possible to delete the psql log while psql is
Date: 2005-12-08 14:09:29
Message-ID: 1134050969.4779.263.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cook, Steve 2005-12-08 15:34:16 Re: is it possible to delete the psql log while psql is running?
Previous Message Martijn van Oosterhout 2005-12-08 14:04:58 Re: is it possible to delete the psql log while psql is