ports/161769: databases/postgresql91-server: su: unknown login: %%PG_USER%%

[Oliver Hartmann]

>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: