[PLUG] psql: ident authentification failed for user "username" error in postgresql....

Shridhar Daithankar ghodechhap at ghodechhap.net
Wed Jan 27 20:18:39 PST 2010


On Wednesday 27 January 2010 22:17:49 Shreerang Patwardhan wrote:
> shreerang at ubuntu:~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm$
> psql -d test_db -U postgres -f import.sql
> *psql: FATAL:  Ident authentication failed for user "postgres"*
> 
> Need help!!!

ident auth authenticates the current user. You are os user shreerang and 
authenticated as such by ident. You cannot authenticate as postgres.

Either connect to the db as shreerang or su to postgres. Alternatively you 
could enable md5 authentication and provide a password.

Additionally, why would postgres be the owner of the db? you can very well run 
it as shreerang or application specific superuser such as gisuser. 

HTH

-- 
Regards 
 Shridhar



More information about the plug-mail mailing list