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
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,
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
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>
Luigi Castro Cardeles
In response to
pgsql-general by date
|Next:||From: Andrew Sullivan||Date: 2008-05-20 15:43:07|
|Subject: Re: Postgresql MVCC, Read Committed Isolation Level andtaking "snapshot"|
|Previous:||From: George Pavlov||Date: 2008-05-20 14:59:37|
|Subject: Re: DB page cache/query performance|