Re: psql ... does not like my user ... help please ;-)

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql ... does not like my user ... help please ;-)
Date: 2002-07-25 13:32:11
Message-ID: 1027603931.8890.29.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd start by logging in as postgres and do "select * from pg_shadow"
This should show you if "jim" has been created as you believe and also
show you if a password has been set. Next I'd do a \l to get a list of
the databases on your system and their owners. I'm thinking jim may not
be authorized to connect to phoneBookDB. HTH

Robert Treat

On Thu, 2002-07-25 at 08:12, jgdon wrote:
> Hello I am playing with a fresh install of mandrake 8.2 and have decided
> to use the postgresql db as my database for a simple phonebook application.
>
> I am following the steps from a tutorial but can't seem to be able to
> access my data base as the user i created ... I keep getting the msg:
>
> psql: FATAL 1: IDENT authentication failed for user "jim"
>
>
> I am going to keep reading ... but i will hopefully get an answer to
> this post quicker [;-)]
>
> Thanks for any help in advance,
> Jim
>
> ps my actual attempt is listed below ...
> bash-2.05$ createuser jim -P
> Enter password for user "jim":
> Enter it again:
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> CREATE USER
>
>
> bash-2.05$ createdb gombaPhoneBookDB
> CREATE DATABASE
>
>
>
> bash-2.05$ psql phoneBookDB -U jim
> psql: FATAL 1: IDENT authentication failed for user "jim"
>
>
>
> bash-2.05$ psql phoneBookDB -u
> psql: Warning: The -u option is deprecated. Use -U.
> User name: jim
> Password:
> psql: FATAL 1: IDENT authentication failed for user "jim"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-07-25 13:32:53 Re: erserver
Previous Message frbn 2002-07-25 13:27:01 Re: Auto DROP SEQUENCE?