Skip site navigation (1) Skip section navigation (2)

Re: newbie-problem

From: denis(at)coralindia(dot)com
To: "Bernard Reissberg" <bernard(dot)reissberg(at)web(dot)de>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: newbie-problem
Date: 2002-01-30 11:39:01
Message-ID: 00c201c1a982$b7391a60$0232a8c0@coralindia.com (view raw or flat)
Thread:
Lists: pgsql-novice
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>

HTH

Denis

----- Original Message -----
From: "Bernard Reissberg" <bernard(dot)reissberg(at)web(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
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
>
>
>
> --
> Bernard Reissberg
>
> http://www.linux-services.net
>
> 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 ReissbergDate: 2002-01-30 12:39:19
Subject: newbie-problem solved.. thanxxx :-))
Previous:From: Oliver ElphickDate: 2002-01-30 11:34:02
Subject: Re: owner of a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group