Skip site navigation (1)Skip section navigation (2)
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>