[postgis-users] RE Importing shapefiles to PostGIS

[P Kishor]

On Sat, Jan 23, 2010 at 8:42 PM, Shreerang Patwardhan
<patwardhan.shreerang at gmail.com> 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"
>


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