On Wednesday 27 January 2010 22:17:49 Shreerang Patwardhan wrote: > shreer...@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 _______________________________________ Pune GNU/Linux Users Group Mailing List
