Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 28 Dec 2003 19:28:46 +0000
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        Gerard Samuel <fbsd-questions@trini0.org>
Cc:        questions@freebsd.org
Subject:   Re: Log Rotation
Message-ID:  <20031228192846.GA1672@happy-idiot-talk.infracaninophile.co.uk>
In-Reply-To: <200312281303.14444.fbsd-questions@trini0.org>
References:  <200312280948.15063.fbsd-questions@trini0.org> <44n09cj142.fsf@be-well.ilk.org> <200312281303.14444.fbsd-questions@trini0.org>

next in thread | previous in thread | raw e-mail | index | archive | help

--zYM0uCDKw75PZbzx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Dec 28, 2003 at 01:03:14PM -0500, Gerard Samuel wrote:
=20
> Yes, Im familiar with newsyslog, but Im not sure how it will play with=20
> rotating PostgreSQL's log file, as PostgreSQL seems to need some extra TL=
C=20
> 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

--=20
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

--zYM0uCDKw75PZbzx
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQE/7y7udtESqEQa7a0RAs0/AJ4/dfkaW3ssfb8t3+G0QgsUuD2lhgCfcBdW
Tb3NOpRhCNIdXPnnnCwO4vc=
=+2W/
-----END PGP SIGNATURE-----

--zYM0uCDKw75PZbzx--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20031228192846.GA1672>