Log Rotation

[Matthew Seaman]

On Sun, Dec 28, 2003 at 01:03:14PM -0500, Gerard Samuel wrote:
 
> Yes, Im familiar with newsyslog, but Im not sure how it will play with 
> rotating PostgreSQL's log file, as PostgreSQL seems to need some extra TLC 
> when rotating the log while PostgreSQL is running.
> http://www.postgresql.org/docs/7.3/interactive/logfile-maintenance.html
> Ill have to let that sink in the brain, before I try messing with it.

http://www.cronolog.org/ -- configure postgresql to log to stdout or
stderr and pipe the data into cronolog.  It will generate logfiles
based on the time & date, but you'll have to write a script to deal
with the oldest log files.

It's in ports as sysutils/cronolog

	Cheers,

	Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.                       26 The Paddocks
                                                      Savill Way
PGP: http://www.infracaninophile.co.uk/pgpkey         Marlow
Tel: +44 1628 476614                                  Bucks., SL7 1TH UK
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20031228/0fcd2706/attachment.bin