[7.0.2] rotating log files ... - Mailing list pgsql-admin

From The Hermit Hacker
Subject [7.0.2] rotating log files ...
Date
Msg-id Pine.BSF.4.21.0008281456510.564-100000@thelab.hub.org
Whole thread Raw
Responses Re: [7.0.2] rotating log files ...  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-admin
can someone recommend on how to rotate the following log files without
having to stop/start the server?

postgres 85333 pgsql    1w  VREG  13,131084       995 762037 /pgsql/logs/postmaster.5432.61308
postgres 85333 pgsql    2w  VREG  13,131084 316501241 762038 /pgsql/logs/5432.61308

its the 316meg one and growing that I'm more interested in doing, obviously ...

I'm starting my postmaster as:

#!/bin/tcsh
setenv PORT 5432
setenv POSTMASTER /pgsql/bin/postmaster
unlimit
${POSTMASTER} -B 384 -N 192 \
              -o "-F -o /pgsql/logs/${PORT}.$$ -S 32768" \
              -i -p ${PORT} -D/pgsql/data >& /pgsql/logs/postmaster.${PORT}.$$ &

where I was hoping that the '-o /pgsql/logs/${PORT}.$$' would create a
'per postgres process' log file, but $$ is taking on the PID of the parent
process, not the children ...

suggestions?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-admin by date:

Previous
From: HENAFF Mari-mai FTRD/DMI/LAN
Date:
Subject: disable auto-commit
Next
From: "Mitch Vincent"
Date:
Subject: Re: [7.0.2] rotating log files ...