From postgresql-admin Thu Aug 13 00:36:26 1998 From: Bernd Johannes Wuebben Date: Thu, 13 Aug 1998 00:36:26 +0000 To: postgresql-admin Subject: [ADMIN] FATAL 1: SetUserId: X-MARC-Message: https://marc.info/?l=postgresql-admin&m=90296864307261 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 --------------------------------------------------------------------