From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | [7.0.2] rotating log files ... |
Date: | 2000-08-28 17:59:12 |
Message-ID: | Pine.BSF.4.21.0008281456510.564-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-08-28 18:25:39 | Re: [7.0.2] rotating log files ... |
Previous Message | HENAFF Mari-mai FTRD/DMI/LAN | 2000-08-28 12:59:17 | disable auto-commit |