Postgres Pro
Downloads
Home   >   mailing lists

Thread: logfile problem?

logfile problem?

From
"tw_vincent"
Date:
Dear All:
 
        I start postgresql with "/app/pgsql/bin/pg_ctl start -l /app/pgsql/logfile -D /app/pgsql/data",
when I use "cat /dev/null > /app/pgsql/logile" to clear logfile, I can't clear logfile. How can I
clear the logfile, thank you!
 
vincent

Re: logfile problem?

From
Bruce Momjian
Date:
tw_vincent wrote:
> Dear All:
>
>    I start postgresql with "/app/pgsql/bin/pg_ctl start -l
>    /app/pgsql/logfile -D /app/pgsql/data", when I use "cat
> /dev/null > /app/pgsql/logile" to clear logfile, I can't clear
> logfile. How can I clear the logfile, thank you!

The problem is that the log file is still being written to by the
postmaster. You can pipe into the rotatelogs script that is part of
Apache, or use syslog.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073