From owner-freebsd-ports-bugs@FreeBSD.ORG  Tue Oct 18 15:20:08 2011
Return-Path: <owner-freebsd-ports-bugs@FreeBSD.ORG>
Delivered-To: freebsd-ports-bugs@hub.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 81CBA1065679
	for <freebsd-ports-bugs@hub.freebsd.org>;
	Tue, 18 Oct 2011 15:20:08 +0000 (UTC)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.freebsd.org
	[IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id 5C77F8FC0A
	for <freebsd-ports-bugs@hub.freebsd.org>;
	Tue, 18 Oct 2011 15:20:08 +0000 (UTC)
Received: from freefall.freebsd.org (localhost [127.0.0.1])
	by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id p9IFK8Rp027678
	for <freebsd-ports-bugs@freefall.freebsd.org>;
	Tue, 18 Oct 2011 15:20:08 GMT
	(envelope-from gnats@freefall.freebsd.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.14.4/8.14.4/Submit) id p9IFK8ri027677;
	Tue, 18 Oct 2011 15:20:08 GMT (envelope-from gnats)
Resent-Date: Tue, 18 Oct 2011 15:20:08 GMT
Resent-Message-Id: <201110181520.p9IFK8ri027677@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, R Dicaire <kritek@gmail.com>
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 67B05106566B
	for <freebsd-gnats-submit@FreeBSD.org>;
	Tue, 18 Oct 2011 15:16:18 +0000 (UTC)
	(envelope-from nobody@FreeBSD.org)
Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22])
	by mx1.freebsd.org (Postfix) with ESMTP id 586B58FC15
	for <freebsd-gnats-submit@FreeBSD.org>;
	Tue, 18 Oct 2011 15:16:18 +0000 (UTC)
Received: from red.freebsd.org (localhost [127.0.0.1])
	by red.freebsd.org (8.14.4/8.14.4) with ESMTP id p9IFGImK045996
	for <freebsd-gnats-submit@FreeBSD.org>; Tue, 18 Oct 2011 15:16:18 GMT
	(envelope-from nobody@red.freebsd.org)
Received: (from nobody@localhost)
	by red.freebsd.org (8.14.4/8.14.4/Submit) id p9IFGIu1045995;
	Tue, 18 Oct 2011 15:16:18 GMT (envelope-from nobody)
Message-Id: <201110181516.p9IFGIu1045995@red.freebsd.org>
Date: Tue, 18 Oct 2011 15:16:18 GMT
From: R Dicaire <kritek@gmail.com>
To: freebsd-gnats-submit@FreeBSD.org
X-Send-Pr-Version: www-3.1
Cc: 
Subject: ports/161774: postgresql init script error
X-BeenThere: freebsd-ports-bugs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Ports bug reports <freebsd-ports-bugs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports-bugs>, 
	<mailto:freebsd-ports-bugs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports-bugs>
List-Post: <mailto:freebsd-ports-bugs@freebsd.org>
List-Help: <mailto:freebsd-ports-bugs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports-bugs>, 
	<mailto:freebsd-ports-bugs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 18 Oct 2011 15:20:08 -0000


>Number:         161774
>Category:       ports
>Synopsis:       postgresql init script error
>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 Oct 18 15:20:07 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator:     R Dicaire
>Release:        8.2 Release
>Organization:
>Environment:
FreeBSD ws.int.kritek.net 8.2-RELEASE-p2 FreeBSD 8.2-RELEASE-p2 #4 r223036M: Wed Oct  5 10:27:02 EDT 2011     root@ws.int.kritek.net:/usr/obj/usr/src/sys/WS  amd64

>Description:
Postgresql port upgrade from 8.4.8_2 to 8.4.9 introduces changes to /usr/local/etc/rc.d/postgresql init script that cause database start to fail with error:

/usr/local/etc/rc.d/postgresql start
su: unknown login: %%PG_USER%%

This is the line from /usr/local/etc/rc.d/postgresql:

postgresql_user=${postgresql_user:-"%%PG_USER%%"}

>How-To-Repeat:
Execute /usr/local/etc/rc.d/postgresql start

>Fix:
Set postgresql_user="pgsql" in /etc/rc.conf.
This was the definition as set in the init script prior to the port upgrade.


>Release-Note:
>Audit-Trail:
>Unformatted: