Date: Tue, 18 Oct 2011 10:57:31 GMT From: Oliver Hartmann <ohartman@zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/161769: databases/postgresql91-server: su: unknown login: %%PG_USER%% Message-ID: <201110181057.p9IAvVUN037264@red.freebsd.org> Resent-Message-ID: <201110181100.p9IB0LRB077062@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201110181057.p9IAvVUN037264>