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

Re: psql: FATAL: Ident authentication failed for user "postgres"

From: "Dan Joo" <djoo(at)agraquest(dot)com>
To: "Luigi Castro Cardeles" <luigi(dot)cardeles(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql: FATAL: Ident authentication failed for user "postgres"
Date: 2008-05-20 15:24:30
Message-ID: 4676DF8318F32F4AB7E98BCD9BC90628E861FA@agq-ex01.agraquest.int (view raw or flat)
Thread:
Lists: pgsql-general
Hi Luigi,

 

It is Linux.  I am trying to login as postgres but as a user not in the
database.  This is because I will be creating a web front end, and
various users, not registered in the database, will need to access the
database.  Thus, as "postgres" I can log in fine:

 

bash-3.1$ psql kermit -U postgres

Welcome to psql 8.1.11, the PostgreSQL interactive terminal.

 

Type:  \copyright for distribution terms

       \h for help with SQL commands

       \? for help with psql commands

       \g or terminate with semicolon to execute query

       \q to quit

 

kermit=#

 

But as myself, I can't.

/home/djoo[8:25am]$ %psql kermit -U postgres

psql: FATAL:  Ident authentication failed for user "postgres"

 

This is pretty much the same setup I had with another company, so I am
confused why I can't access.  Is there another file that I need to alter
besides the pg_hba.conf file?  

 

Thanks for your help,

 

Dan

 

From: Luigi Castro Cardeles [mailto:luigi(dot)cardeles(at)gmail(dot)com] 
Sent: Tuesday, May 20, 2008 5:53 AM
To: Dan Joo
Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed for user
"postgres"

 

hi,

what's your machine configuration? Linux, Mac Os?
if you are using mac, maybe you have a problem with identd.

what user are you trying to logon?

comand: psql -U <user-name> -d <database-name>
[]'s

-- 
Luigi Castro Cardeles 

In response to

Responses

pgsql-general by date

Next:From: Andrew SullivanDate: 2008-05-20 15:43:07
Subject: Re: Postgresql MVCC, Read Committed Isolation Level andtaking "snapshot"
Previous:From: George PavlovDate: 2008-05-20 14:59:37
Subject: Re: DB page cache/query performance

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