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>