[postgis-users] RE Importing shapefiles to PostGIS

Emilie Laffray emilie.laffray at gmail.com
Sat Jan 23 03:51:02 PST 2010

On 23/01/2010 04:00, 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!!!

You have an identification problem for the user postgres. This is not a
Postgis related issue per se. You have to enter the password for
postgres somehow.

Emilie Laffray

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100123/3c360058/attachment.pgp>

More information about the postgis-users mailing list