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

Shreerang Patwardhan patwardhan.shreerang at gmail.com
Wed Jan 27 08:47:49 PST 2010


Hey all,
     I am new to using PostgreSQL and PostGIS. I am using Ubuntu 9.04 and
PostgreSQL 8.4 and PostGIS 1.4. I wish to upload some TIGER shapefiles to
PostGIS.I have followed steps to import TIGER shapefile to PostGIS . I  got
the following output and errors.

shreerang at ubuntu:~/Shapefiles/
06001_Alameda_County/tl_2008_06001_arealm$ shp2pgsql -s 4326 -I -S
tl_2008_06001_arealm.shp public.test_db > tl_2008_06001_arealm.sql
Shapefile type: Polygon
Postgis type: POLYGON[2]

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!!!


Thanx,
Shreerang.


More information about the plug-mail mailing list