Hello all,<br> I have followed the following steps to import TIGER shapefile to PostGIS . I got the following output and errors.<br><br>shreerang@ubuntu:~/Shapefiles/<div><div class="im">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<br>
Shapefile type: Polygon<br>Postgis type: POLYGON[2]<br><br>shreerang@ubuntu:~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm$ psql -d test_db -U postgres -f import.sql<br>psql: FATAL: Ident authentication failed for user "postgres"<br>
<br><br></div>Now, I followed the following procedure. I wish to know if it is right or wrong.<br><br>The first command is as it is....<br>For the next one,<br><br>shreerang@ubuntu:~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm$ sudo su postgres<br>
[sudo] password for shreerang: <br>$ psql -U postgres<br>could not change directory to "/home/shreerang/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm"<br>Welcome to psql 8.3.9, the PostgreSQL interactive terminal.<br>
<br>Type: \copyright for distribution terms<br> \h for help with SQL commands<br> \? for help with psql commands<br> \g or terminate with semicolon to execute query<br> \q to quit<br><br>postgres=# psql -d test_db -U postgres -f import.sql<br>
<br>Is this right?<br>And what should the output look like if this is right?...<br>
<br>Need help!!!<br><br><br>Thanx,<br><font color="#888888"><font color="#888888">Shreerang.</font></font></div>