[postgis-users] postgis account setting

[TECHER David]

Hi

Kuo

In a DOS prompt do

If U are logged as "Kuo" user

shp2pgsql -D maryland_road.shp road maryland | psql -U Kuo -d maryland

if "Kuo" is a postgresql's super-user  (if U have created it with
"createuser -s Kuo" for example)

or since postgres is the owner of maryland's database

shp2pgsql -D maryland_road.shp road maryland | psql -U postgres -d maryland

Don't forget that "postgres" must be a simple user on windows  not a
administrator with admin' rights (= super-user of your computer)



K Kuo a écrit :

> Hi all,
> I got problems while running shp2pgsql with windows xp command prompt.
> My command is like: shp2pgsql -D maryland_road.shp road maryland |
> psql maryland
> and got the message as: psql: FATAL: password authentication failed
> for user "Kuo"
> "Kuo" is my account name for windows xp. I create maryland database
> under user name "postgres" which was created by postgreSQL while
> installation. However, it does not appear neither on xp login screen
> nor user account in xp. I tried to create an account of " postgres"
> which I can log in whith xp and probably avoid above problem but xp
> told me that this account already exists. It seems that there is no
> option for changing user name with shp2pgsql command. Is there a way
> to run shp2pgsql under user name "Kuo"? or how to avoid account
> restrict problem in the future?
>
> thanks,
>
> kuo
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


	

	
		
___________________________________________________________________________ 
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com