Re: pq_shadow

webmaster writes:

> [root(at)crescent1 root]# createuser webmaster -P
> Enter password for user "webmaster":
> Enter it again:
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> psql: FATAL 1: SetUserId: user 'root' is not in 'pg_shadow'
> createuser: creation of user "webmaster" failed
> [root(at)crescent1 root]#

createuser needs to connect to the database in order to create new users.
In order to connect to the database, it needs to connect with an *already
existing* database user name. "root" is apparently no such user name.
If this is a newly initdb'ed site, then the only user name that exists is
"postgres" (or whatever the name of your Unix PostgreSQL account). Either
you login in (su) as postgres, or you use createuser -U postgres.

Incidentally, this is not a bug and should be posted elsewhere.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/