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

Authentication problems

From: the inquirer <listquestions(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Authentication problems
Date: 2004-08-20 15:33:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-novice
I am a new postgres user who is having trouble
figuring out how user-based authentication is supposed
to work.  I create a database, create a user and
attempt to use psql to connect to the new database
using the new user.  However, the server always
responds with "psql: FATAL: IDENT authentication
failed for user "user".  Are there additionaly
security of configuration tasks that need to be done? 

Here are the commands I am executing as the user

$ createdb database
$ createuser -P user
Enter password for new user:
Enter it again:
Shall the new user be allowed to create databases?
(y/n) n
Shall the new user be allowed to create more new
users? (y/n) n
$ psql -W -d database -U user
psql:  FATAL: IDENT authentication failed for user

I am running on Debian Sarge kernel versin 2.4.25-1. 
All of my postgresql pkgs are 7.4.3-3.


Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.


pgsql-novice by date

Next:From: SVGK, Raju (Raju)Date: 2004-08-20 15:56:34
Subject: view triggers/procedures
Previous:From: Tom LaneDate: 2004-08-20 15:15:00
Subject: Re: dup(0) failed after 3195 successes: Bad file descriptor

pgsql-general by date

Next:From: John Sidney-WoollettDate: 2004-08-20 15:43:14
Subject: Re: insert waiting
Previous:From: Tom LaneDate: 2004-08-20 15:29:16
Subject: Re: Postgres "invalid page header"

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