[PLUG] psql: ident authentification failed for user "username" error in postgresql....
Shreerang Patwardhan
patwardhan.shreerang at gmail.com
Fri Jan 29 09:38:48 IST 2010
Hi all,
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 > 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 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!!!
More information about the Plug-mail
mailing list