[postgis-users] RE Importing shapefiles to PostGIS

[Ben Madin]

It's probably bad practice to log in as the postgres user - log in to psql, and create a new user (without a password for now), with their own database. If your computer is secure, or you don't care, create the new user as a superuser.

Try the following:

http://www.postgresql.org/docs/8.4/interactive/user-manag.html

http://www.postgresql.org/docs/8.4/interactive/sql-createrole.html <- note that you want to create user, but read this page.

cheers

Ben



On 24/01/2010, at 10:42 , Shreerang Patwardhan wrote:

> Hello all,
>         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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users