How To: rotate logs, when installed as a service

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/

Browse pgsql-cygwin by date

  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