From owner-freebsd-questions@FreeBSD.ORG Sun Dec 28 11:28:58 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7EA5316A4CE for ; Sun, 28 Dec 2003 11:28:58 -0800 (PST) Received: from smtp.infracaninophile.co.uk (happy-idiot-talk.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id AB48543D31 for ; Sun, 28 Dec 2003 11:28:55 -0800 (PST) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [127.0.0.1]) hBSJSlwd001776 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sun, 28 Dec 2003 19:28:47 GMT (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)id hBSJSk00001775; Sun, 28 Dec 2003 19:28:46 GMT (envelope-from matthew) Date: Sun, 28 Dec 2003 19:28:46 +0000 From: Matthew Seaman To: Gerard Samuel Message-ID: <20031228192846.GA1672@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , Gerard Samuel , Lowell Gilbert , questions@freebsd.org References: <200312280948.15063.fbsd-questions@trini0.org> <44n09cj142.fsf@be-well.ilk.org> <200312281303.14444.fbsd-questions@trini0.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="zYM0uCDKw75PZbzx" Content-Disposition: inline In-Reply-To: <200312281303.14444.fbsd-questions@trini0.org> User-Agent: Mutt/1.5.5.1i X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.61 X-Spam-Checker-Version: SpamAssassin 2.61 (1.212.2.1-2003-12-09-exp) on happy-idiot-talk.infracaninophile.co.uk cc: questions@freebsd.org Subject: Re: Log Rotation X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 28 Dec 2003 19:28:58 -0000 --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--