From: | Patrick Samson <p_samson(at)yahoo(dot)com> |
---|---|
To: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | How To: rotate logs, when installed as a service |
Date: | 2004-07-22 07:56:34 |
Message-ID: | 20040722075634.81690.qmail@web60308.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I run postgres as a service with cygrunsrv.
According to cygrunsrv's README, it may one day
be able to pipe stdout/stderr. But not yet.
So if you do a standard installation,
/var/log/postmaster.log grows indefinitely.
Here is a way to renew the log file regularly:
- get the rotatelogs component from the apache
package:
. download the apache package with setup.exe
. copy release\apache\apache-<version>.tar.bz2
in /tmp
. cd /
. tar -jxf /tmp/apache*.bz2
usr/share/man/man8/rotatelogs.8
usr/sbin/rotatelogs.exe
- change some parameters of cygrunsrv --install
or directly change them in the registry
(HKLM\System\CurrentControlSet\Services\postmaster)
-path /usr/bin/bash.exe
--args "--login -c \'/usr/local/pgsql/bin/postmaster
-D /usr/share/pgsql/data i -c log_timestamp=1 2>&1 |
/usr/sbin/rotatelogs /var/log/pgsql 604800\'"
Notes:
- I run a 7.3.6 version, so you may have to adjust
the paths to postmaster and data to different new
settings.
- I'm used to set --login when I run a bash.
Didn't check if it's really mandatory here.
- 604800 means a week in seconds.
It seems to work fine.
But one minor defect is that these 3 lines do not
appear in the log when the service is stopped:
<datetime> LOG: fast shutdown request
<datetime> LOG: shutting down
<datetime> LOG: database system is shut down
I guess that rotatelogs.exe is terminated even before
to get the last output of postgres.exe.
Any idea to improve this last point?
[Jason, As a user, I would have been happy to find
such directions in the README file, at least as
a suggested example. Of course, it's up to you.]
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2004-07-22 12:00:16 | Re: To cygwin postgresql maintainer: tutorial RFC |
Previous Message | Carlo Florendo | 2004-07-22 01:50:57 | To cygwin postgresql maintainer: tutorial RFC |