When you connect to postgres without using option -u, it tries to connect to
postgres with current user (of linux).
It seems that you are logged on to linux with user "bernard". It is trying
to connect to database with this user id but it is not getting that username
in postgres user database...
You need to create one user from linux shell prompt .. with this command
createuser bernard with password <yourpassword>
----- Original Message -----
From: "Bernard Reissberg" <bernard(dot)reissberg(at)web(dot)de>
Sent: Wednesday, January 30, 2002 3:58 PM
Subject: [NOVICE] newbie-problem
> Hi folks! :-)
> I have a problem with my first steps with postgresql. I installed
> the database-server on my LINUX-box (debian potato) and wanted to
> try out the first operations with psql. When I call psql, I get the
> following error message:
> Connection to database 'template1' failed
> FATAL1: SetUserId: user 'bernard' is not in 'pg_shadow'
> I don't know what to do. Sure, this is a stupid question. But it is
> really my first contact with a database.
> Thank you very much!
> Bernard Reissberg
> Linux & Open Source... my way!
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-novice by date
|Next:||From: Bernard Reissberg||Date: 2002-01-30 12:39:19|
|Subject: newbie-problem solved.. thanxxx :-))|
|Previous:||From: Oliver Elphick||Date: 2002-01-30 11:34:02|
|Subject: Re: owner of a table|