Обсуждение: log rotation script for server output
Hi, group,
Does any one of you write log rotation script for postgresql server output? Can you share with us?
shell> pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfiles/activity.log -o -i
Thank you
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
On Tue, Mar 25, 2003 at 12:32:53 -0800, Flower Sun <sun_2002_flower@yahoo.com> wrote: > > Hi, group, > > Does any one of you write log rotation script for postgresql server output? Can you share with us? > > shell> pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfiles/activity.log -o -i You can pipe the output into multilog (from DJB's daemontools package).
On Tue, 25 Mar 2003, Flower Sun wrote: > > Hi, group, > > Does any one of you write log rotation script for postgresql server output? Can you share with us? > > shell> pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfiles/activity.log -o -i I use rotatelogs from the apache package. Make sure it's in the postgres super user's path, create a directory for the logs that the postgres user can write to (I use $PGDATA/pglog here) then put this line in rc.local: su - postgres -c 'pg_ctl start | rotatelogs $PGDATA/pglog 86400 2>1&' Note that that's apache 1.3.x. I haven't really had time or a need to look at 2.x apache yet.
I use logrotate-3.6.5-2.rpm on a red hat with the following config file /var/log/pglog { rotate 2 size=1M copytruncate delaycompress compress } Just to show how flexiable this logrotator is... But the official word is that let syslog handle it.... Bruno Wolff III wrote: >On Tue, Mar 25, 2003 at 12:32:53 -0800, > Flower Sun <sun_2002_flower@yahoo.com> wrote: > > >>Hi, group, >> >>Does any one of you write log rotation script for postgresql server output? Can you share with us? >> >>shell> pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfiles/activity.log -o -i >> >> > >You can pipe the output into multilog (from DJB's daemontools package). > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly > >
On Tue, Mar 25, 2003 at 14:21:37 -0800, Flower Sun <sun_2002_flower@yahoo.com> wrote: > > Hi, Bruno, > Thank you very much for your reply. Can you give me more information about DJB's daemontools? The package is at: http://cr.yp.to/daemontools.html There is documentation there about how to use it. You can just use multilog by piping the output from postmaster through it or you can even run postgres using daemontools instead of using init. I am currently using daemontools to run postgres and using multilog for logging.