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(at)kde(dot)org
wuebben(at)math(dot)cornell(dot)edu wuebben(at)acm(dot)org
--------------------------------------------------------------------