ports/161774: postgresql init script error

[R Dicaire]

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