[postgis-users] RE Importing shapefiles to PostGIS

Shreerang Patwardhan patwardhan.shreerang at gmail.com
Thu Jan 28 20:06:39 PST 2010

Hi all,
    I am still stuck at this "Ident authentification error"...[?] The
sequence of commands that I used and their outputs are as below:

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

shreerang at ubuntu:~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm$
psql -d testdb -h localhost -p 5432 -U postgres
Welcome to psql 8.3.9 (server 8.4.2), the PostgreSQL interactive terminal.

testdb=# psql -d testdb -U postgres -f tl_2008_06001_arealm.sql

What should be the output of this command at the terminal? On entering this
command the terminal gives a new promt. Is this the desired output?

When I use the command  testdb-# \d  I get the output as:

              List of relations
 Schema |       Name       | Type  |  Owner
 public | geometry_columns | table | postgres
 public | spatial_ref_sys  | table | postgres
(2 rows)

Please help guys!!!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100129/01bb821e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 323.png
Type: image/png
Size: 612 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100129/01bb821e/attachment.png>

More information about the postgis-users mailing list