pkg/33663: home directory of pgsql user isn't created by default

[soda%NetBSD.org@localhost]

>Number:         33663
>Category:       pkg
>Synopsis:       home directory of pgsql user isn't created by default
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed Jun 07 16:40:01 +0000 2006
>Originator:     SODA Noriyuki
>Release:        NetBSD 3.0
>Organization:
The NetBSD project
>Environment:
System: NetBSD srapc2586.sra.co.jp 3.0 NetBSD 3.0 (SRAPC2586) #0: Sat Sep 10 
21:01:40 JST 2005 
soda%srapc2586.sra.co.jp@localhost:/usr/prj/src/NetBSD/netbsd-3/src/sys/arch/i386/compile/SRAPC2586
 i386
Architecture: i386
Machine: i386
>Description:

The home directory of pgsql user for PostgreSQL package (i.e /usr/pkg/pgsql,
because the default is ${PREFIX}/${PGUSER}) isn't created by default.
Thus, some third party script, which assumes "su -l ${PGUSER}" works
to invoke pg_ctl, fails.

>How-To-Repeat:

install PostgreSQL server package, and try "su -l pgsql".

>Fix:

Create the home directory? (maybe /var/pgsql is better than /usr/pkg/pgsql?)
Unless we are intentionally making the home directory missing.

FWIW, jlam said he'll handle this issue.