>Number:         7445
>Category:       pkg
>Synopsis:       postgres fails to install if pgsql login exists
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    pkg-manager (NetBSD software packages system bug manager)
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Thu Apr 22 13:20:00 1999
>Last-Modified:
>Originator:     Ingolf Koch
>Organization:
Beste Kneipe in Jena-Ost
>Release:        1.3.3
>Environment:
System: NetBSD maus 1.3.3 NetBSD 1.3.3 (MAUS) #0: Sat Feb 13 23:22:50 MET 1999 ingolf@maus:/usr/obj/sys/arch/amiga/compile/MAUS amiga

>Description:
	During "make install" of postgresql-6.4.2, the directory
    /usr/pkg/pgsql ist removed (rm -fr). If the pgsql login
    does not yet exist, this directory will be created by
    addnerd (see /usr/pkgsrc/databases/postgresql/pkg/REQ).

    But if there is already a pgsql login, the addnerd call
    is skipped, and the /usr/pkg/pgsql is not created.
    make install fails later.

    Additoinally, the REQ script should try to create the
    ingres group _before_ calling addnerd. Otherwise,
    addnerd sets pgsql's group to wheel.

>How-To-Repeat:
	Remove pgsql from your passwd (or nis) data base and ingres
    from your groups file.

    Compile and try to install postgres.

    First, addnerd adds pgsql to passwd (with wheel group), then
    the REQ exits saying "Please add group ingres to /etc/group,
    then restart."

    Add ingres (and correct pgsql's group) and run make install
    again.

    /usr/pkg/pgsql is deleted but not created later on.

>Fix:
	1. Exchange the check for ingres group and the addnerd part
    in /usr/pkgsrc/databases/postgresql/pkg/REQ.

    2. If pgsql already exists, create /usr/pkg/pgsql (or do
    not remove it).
>Audit-Trail:
>Unformatted: