From: | Bernd Johannes Wuebben <wuebben(at)math(dot)cornell(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | FATAL 1: SetUserId: |
Date: | 1998-08-13 00:36:26 |
Message-ID: | XFMail.980812203626.wuebben@math.cornell.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
--------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Marcio Macedo | 1998-08-13 09:01:02 | Re: [ADMIN] FATAL 1: SetUserId: |
Previous Message | Terence Dixon | 1998-08-12 22:33:09 | user is not in "pg_shadow" |