On Sat, Jan 23, 2010 at 8:42 PM, Shreerang Patwardhan <[email protected]> wrote: > Hello all, > I have followed steps to import TIGER shapefile to PostGIS . I got > the following output and errors. > > shreer...@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] > > 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" >
Have you been able to log into Postgres at all? Try logging in as user "postgres" and whatever password you set when you installed it. You can try and force a password prompt with -W. Type psql --help on your command prompt for all the options. su as postgres and then try importing. -- Puneet Kishor _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
