FATAL 1: SetUserId:

Hello,

        I have just installed the latest postgresql rpms on RedHat 5.1:

root: rpm -q postgresql
postgresql-6.3.2-4

root: rpm -q postgresql-data
postgresql-data-6.3.2-4

However I can't get started with postgres as outlined in the tutorial:

wuebben: psql template1
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user "wuebben" is not in "pg_shadow"

The postmaster is running:

root: ps ax | grep post
  580  p1 S    0:00 grep post
  293  ?  S    0:00 /usr/bin/postmaster -S -D/var/lib/pgsql


Why is psql complaining ( and so are createdb and friends ) about:
SetUserId: user "wuebben" is not in "pg_shadow"  if  psql is not even
looking in /var/lib/pg_shadow ( see strace below )? What do I need to
do to get started?

The following doesn't work either ( for any user be it root or wuebben):

root: psql -d template1 -c "create user wuebben"
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user "root" is not in "pg_shadow"

I sincerley hope there is something wrong with the rpms, and not
with the documenation. ;-)

thanks!
Bernd


strace -etrace=open psql template1 > log.txt 2>&1

open("/etc/ld.so.preload", O_RDONLY)    = -1 ENOENT (No such file or
directory)
open("/usr/local/qt/lib/libpq.so.1", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/usr/lib/libpq.so.1", O_RDONLY)   = 3
open("/usr/local/qt/lib/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
open("/usr/local/qt/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/lib/libnsl.so.1", O_RDONLY)      = 3
open("/usr/local/qt/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/lib/libdl.so.2", O_RDONLY)       = 3
open("/usr/local/qt/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/lib/libm.so.6", O_RDONLY)        = 3
open("/usr/local/qt/lib/libreadline.so.3", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/lib/libreadline.so.3", O_RDONLY) = 3
open("/usr/local/qt/lib/libhistory.so.3", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/lib/libhistory.so.3", O_RDONLY) = 3
open("/usr/local/qt/lib/libtermcap.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/lib/libtermcap.so.2", O_RDONLY)  = 3
open("/usr/local/qt/lib/libncurses.so.4", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/lib/libncurses.so.4", O_RDONLY) = 3
open("/usr/local/qt/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/lib/libc.so.6", O_RDONLY)        = 3
open("/etc/nsswitch.conf", O_RDONLY)    = 3
open("/usr/local/qt/lib/libnss_files.so.1", O_RDONLY) = -1 ENOENT (No
such file or directory)
open("/lib/libnss_files.so.1", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY)           = 3
Connection to database 'template1' failed.
FATAL 1:  SetUserId: user "root" is not in "pg_shadow"

--------------------------------------------------------------------
Bernd Johannes Wuebben                          wuebben@kde.org
wuebben@math.cornell.edu                        wuebben@acm.org
--------------------------------------------------------------------