[postgis-users] Authentication failed Postgis

[Nicolas Ribot]

>  I am administrator working on Postgis. I transferred some Esri shape files
> on my Postgis Database and would like to put them on table.To my surprise ,
> as I gave my password I got an authentication failure..
>
>  Can someone help ?
>
>
>
>  C:\Programme\PostgreSQL\8.2\bin>psql -d Diplomarbeit -f
> F104FT.sql
>  Passwort:
>  psql: FATAL:  password authentication failed for user "Rosalie"
>
>  C:\Programme\PostgreSQL\8.2\bin>

Hi,

Is Rosalie, by any chance, your windows admin name and not the pg admin name ?

psql is expecting a postgresql administrator or user name. (maybe
"postgres" if you did a standard installation).
Provide the psql command with the username using the -U switch:

psql -U postgres -d ...

Nicolas