Date: Tue, 10 Jun 2003 09:18:34 -0300 (ART) From: Fernando Schapachnik <fernando@mecon.gov.ar> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/53142: postgres' 010.pgsql.sh restart sends logs to stdout Message-ID: <200306101218.h5ACIYX0000543@bal740r0.mecon.gov.ar> Resent-Message-ID: <200306101230.h5ACU7SC072676@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200306101218.h5ACIYX0000543>