From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Oct 18 11:00:21 2011 Return-Path: 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 99E2E106564A for ; Tue, 18 Oct 2011 11:00:21 +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 4E5F38FC13 for ; Tue, 18 Oct 2011 11:00:21 +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 p9IB0LW3077064 for ; Tue, 18 Oct 2011 11:00:21 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id p9IB0LRB077062; Tue, 18 Oct 2011 11:00:21 GMT (envelope-from gnats) Resent-Date: Tue, 18 Oct 2011 11:00:21 GMT Resent-Message-Id: <201110181100.p9IB0LRB077062@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, Oliver Hartmann Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 6A98C106566C for ; Tue, 18 Oct 2011 10:57:31 +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 5A5158FC13 for ; Tue, 18 Oct 2011 10:57:31 +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 p9IAvV0r037265 for ; Tue, 18 Oct 2011 10:57:31 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.4/8.14.4/Submit) id p9IAvVUN037264; Tue, 18 Oct 2011 10:57:31 GMT (envelope-from nobody) Message-Id: <201110181057.p9IAvVUN037264@red.freebsd.org> Date: Tue, 18 Oct 2011 10:57:31 GMT From: Oliver Hartmann To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/161769: databases/postgresql91-server: su: unknown login: %%PG_USER%% X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Oct 2011 11:00:21 -0000 >Number: 161769 >Category: ports >Synopsis: databases/postgresql91-server: su: unknown login: %%PG_USER%% >Confidential: no >Severity: critical >Priority: high >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Tue Oct 18 11:00:20 UTC 2011 >Closed-Date: >Last-Modified: >Originator: Oliver Hartmann >Release: FreeBSD 8.2-STABLE/amd64 >Organization: FU Berlin >Environment: >Description: While updating port databases/postgresql91-server, the PostgreSQL server won't start afterwards. Neither reboot nor manual restart via /usr/local/etc/rc.d/postgres restart|start will work. >How-To-Repeat: Update port databases/postgresql91-server or install fresh. >Fix: Somehow, the verbose, nonnumerical UID of user pgsql gets lost while the package is beeing built and installed. As a dirty hack, one can fix the problem in the installed startup script residing in /usr/local/etc/rc.d as shown below. --- /usr/local/etc/rc.d/postgresql.orig 2011-10-18 12:44:40.000000000 +0200 +++ /usr/local/etc/rc.d/postgresql 2011-10-18 12:45:45.000000000 +0200 @@ -32,7 +32,7 @@ # set defaults postgresql_enable=${postgresql_enable:-"NO"} postgresql_flags=${postgresql_flags:-"-w -s -m fast"} -postgresql_user=${postgresql_user:-"%%PG_USER%%"} +postgresql_user=${postgresql_user:-"pgsql"} eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"} postgresql_class=${postgresql_class:-"default"} postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"} >Release-Note: >Audit-Trail: >Unformatted: