[postgis-users] RE Importing shapefiles to PostGIS

[P Kishor]

On Sat, Jan 23, 2010 at 10:25 PM, Ben Madin
<lists at remoteinformation.com.au> wrote:
> 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.

Please explain why it is bad practice to log in as 'postgres' but ok
to create a new user with a password or as a superuser? An explanation
would be an useful addendum to advice such as above.


>
> 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.
>>
>> 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"
>>
>> Need help!!!
>>
>>
>> Thanx,
>> Shreerang.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================