It's probably bad practice to log in as the postgres user - log in to psql, and create a new user (without a password for now), with their own database. If your computer is secure, or you don't care, create the new user as a superuser.
Try the following: http://www.postgresql.org/docs/8.4/interactive/user-manag.html http://www.postgresql.org/docs/8.4/interactive/sql-createrole.html <- note that you want to create user, but read this page. cheers Ben On 24/01/2010, at 10:42 , Shreerang Patwardhan wrote: > Hello all, > I have followed steps to import TIGER shapefile to PostGIS . I got > the following output and errors. > > shreer...@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] > > shreer...@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!!! > > > Thanx, > Shreerang. > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
