From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Jun 10 05:30:09 2003 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4CE8F37B401 for ; Tue, 10 Jun 2003 05:30:09 -0700 (PDT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id EC20143FDD for ; Tue, 10 Jun 2003 05:30:07 -0700 (PDT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.9/8.12.9) with ESMTP id h5ACU7Up072677 for ; Tue, 10 Jun 2003 05:30:07 -0700 (PDT) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.9/8.12.9/Submit) id h5ACU7SC072676; Tue, 10 Jun 2003 05:30:07 -0700 (PDT) Resent-Date: Tue, 10 Jun 2003 05:30:07 -0700 (PDT) Resent-Message-Id: <200306101230.h5ACU7SC072676@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Fernando Schapachnik Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 57E0537B401 for ; Tue, 10 Jun 2003 05:20:43 -0700 (PDT) Received: from relay2.mecon.ar (relay2.mecon.ar [168.101.16.11]) by mx1.FreeBSD.org (Postfix) with ESMTP id D0A9E43F93 for ; Tue, 10 Jun 2003 05:20:41 -0700 (PDT) (envelope-from fpscha@mecon.gov.ar) Received: from racing.mecon.ar (racing.mecon.ar [168.101.133.15]) by relay2.mecon.ar (8.12.6p2/8.12.6) with ESMTP id h5ACKeEt080264 for ; Tue, 10 Jun 2003 09:20:40 -0300 (ART) (envelope-from fpscha@mecon.gov.ar) Received: from racing.mecon.ar (meyosp.mecon.gov.ar [10.11.0.149]) by racing.mecon.ar (8.12.6/8.12.6) with ESMTP id h5ACIYQ0052194 for ; Tue, 10 Jun 2003 09:18:34 -0300 (ART) (envelope-from fpscha@mecon.gov.ar) Received: from bal740r0.mecon.gov.ar (bal740r0.mecon.ar [10.11.1.11]) by racing.mecon.ar (8.12.6/8.12.6) with ESMTP id h5ACIYNc052191 for ; Tue, 10 Jun 2003 09:18:34 -0300 (ART) (envelope-from fpscha@mecon.gov.ar) Received: from bal740r0.mecon.gov.ar (localhost [127.0.0.1]) by bal740r0.mecon.gov.ar (8.12.6/8.12.6) with ESMTP id h5ACIYIs000544 for ; Tue, 10 Jun 2003 09:18:34 -0300 (ART) (envelope-from fpscha@bal740r0.mecon.gov.ar) Received: (from fpscha@localhost) by bal740r0.mecon.gov.ar (8.12.6/8.12.6/Submit) id h5ACIYX0000543; Tue, 10 Jun 2003 09:18:34 -0300 (ART) (envelope-from fpscha) Message-Id: <200306101218.h5ACIYX0000543@bal740r0.mecon.gov.ar> Date: Tue, 10 Jun 2003 09:18:34 -0300 (ART) From: Fernando Schapachnik To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/53142: postgres' 010.pgsql.sh restart sends logs to stdout X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Fernando Schapachnik List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Jun 2003 12:30:09 -0000 >Number: 53142 >Category: ports >Synopsis: postgres' 010.pgsql.sh restart sends logs to stdout >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Tue Jun 10 05:30:07 PDT 2003 >Closed-Date: >Last-Modified: >Originator: Fernando Schapachnik >Release: FreeBSD 4.7-RELEASE-p9 i386 >Organization: >Environment: System: FreeBSD bal740r0.mecon.gov.ar 4.7-RELEASE-p9 FreeBSD 4.7-RELEASE-p9 #4: Mon Mar 24 14:27:42 ART 2003 root@bal740r0.mecon.gov.ar:/usr/obj/usr/src/sys/BAL740R0 i386 pkg_info -I postgresql-\* postgresql-7.3.3 The most advanced open-source database available anywhere >Description: The control script that ships with the postgres port (/usr/local/etc/rc.d/0.10.pgsql.sh) lacks a parameter in the restart option, causing logs to be send to stdout, instead of the log file. >How-To-Repeat: Set log_statement = true in ~pgsql/data/postgresql.conf, then issue: /usr/local/etc/rc.d/010.pgsql.sh restart Output: [78040] LOG: database system was shut down at 2003-06-09 02:00:13 ART [78040] LOG: checkpoint record is at 0/1A2C2D9C [78040] LOG: redo record is at 0/1A2C2D9C; undo record is at 0/0; shutdown TRUE [78040] LOG: next transaction id: 236987; next oid: 447527 [78040] LOG: database system is ready >Fix: --- 010.pgsql.sh.original Tue Jun 10 09:12:43 2003 +++ 010.pgsql.sh Tue Jun 10 09:13:10 2003 @@ -32,7 +32,7 @@ restart) [ -x ${PGBIN}/pg_ctl ] && { - exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast" + exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast -l ${logfile}" } ;; >Release-Note: >Audit-Trail: >Unformatted: