From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, gabor <gabor(at)nekomancer(dot)net> |
Subject: | Re: is it possible to delete the psql log while psql is |
Date: | 2005-12-08 22:26:38 |
Message-ID: | 200512081526.38350.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Ed
>
> Oleg
>
> On Thu, 8 Dec 2005, gabor wrote:
> > hi,
> >
> > i'd like to delete the postgresql log file
> > (resides in /var/log/pgsql/postgres),
> > because it has become too big.
> >
> > can i simply delete the file while postgresql is running?
> >
> > or do i have to stop postgresql first, and only delete the
> > logfile after that?
> >
> > thanks,
> > gabor
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet
> (www.astronet.ru) Sternberg Astronomical Institute, Moscow
> University, Russia Internet: oleg(at)sai(dot)msu(dot)su,
> http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83,
> +007(495)939-23-83
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: don't forget to
> increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus Moor | 2005-12-08 22:54:01 | find last day of month |
Previous Message | Tom Lane | 2005-12-08 21:03:51 | Re: Specify schema in jdbc connection string? |