[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: [ADMIN] FATAL 1: SetUserId:
From: Bernd Johannes Wuebben <wuebben () math ! cornell ! edu>
Date: 1998-08-13 0:36:26
[Download RAW message or body]
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
--------------------------------------------------------------------
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic