From owner-freebsd-questions@FreeBSD.ORG  Sat Jun 14 11:21:29 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 E8F7D37B401
	for <freebsd-questions@FreeBSD.ORG>;
	Sat, 14 Jun 2003 11:21:29 -0700 (PDT)
Received: from hotmail.com (law15-f44.law15.hotmail.com [64.4.23.44])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8E36743F85
	for <freebsd-questions@FreeBSD.ORG>;
	Sat, 14 Jun 2003 11:21:29 -0700 (PDT)
	(envelope-from curioso1100@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Sat, 14 Jun 2003 11:21:29 -0700
Received: from 80.58.1.170 by lw15fd.law15.hotmail.msn.com with HTTP;
	Sat, 14 Jun 2003 18:21:29 GMT
X-Originating-IP: [80.58.1.170]
X-Originating-Email: [curioso1100@hotmail.com]
From: "Emilio Manuel" <curioso1100@hotmail.com>
To: freebsd-questions@FreeBSD.ORG
Date: Sat, 14 Jun 2003 18:21:29 +0000
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Message-ID: <Law15-F44wQ1AoMEDYm00039ec8@hotmail.com>
X-OriginalArrivalTime: 14 Jun 2003 18:21:29.0526 (UTC)
	FILETIME=[C6579D60:01C332A1]
Subject: problem Postgres rotation logs
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 14 Jun 2003 18:21:30 -0000

I use Postgres as database for my web site. Postgres write logs to 
/var/log/pgsql.log.

To make log rotation, I append:

/var/log/pgsql          pgsql:pgsql     600  4     *    $W0D23  Z

to /etc/newsyslog

The rotation works fine and Postgres still work after it occurs, but until I 
stop and start again Postgres, it doesn’t write any line to the new file 
/var/log/pgsql.log

¿What am I doing wrong?

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.yupimsn.com/