> > CREATE USER sql command updates the file, but an UPDATE on pg_shadow
> > does not.
>
> How about INSERT INTO pg_shadow? Or how do you judge the
> following excerpt
> from the createuser script:
>
> QUERY="insert into pg_shadow \
> (usename, usesysid, usecreatedb, usetrace, usesuper,
> usecatupd) \
> values \
> ('$NEWUSER', $SYSID, '$CANCREATE', 'f', '$CANADDUSER','f')"
>
> Fortunately (perhaps), I am getting rid of this as we're
> speaking. The one
> feature the createuser script has over the CREATE USER "SQL"
> command is
> that you can pick your system ID. Ignoring the question whether or not
> this has any real purpose, it seems this is almost like
> rolling dice since
The sysid is essential for one of the authentication methods available in
PostgreSQL
(was it ident, I forgot) where the unix system password was used.
Andreas