[PLUG] psql: ident authentification failed for user "username" error in postgresql....
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.
More information about the plug-mail