Hi, Are you sure you provide the database user password, or the OS user pwd ? Are you in "ident sameuser" mode, in the pg_hba.conf file ? If so, you can only authenticate to the database if you are logged in the os with the same user as the one needed for Postgresql.
Nicolas On 14 November 2011 09:53, Richard White <[email protected]> wrote: > Hi, > > > > I have been using shp2pgsql to load shape files into a PostGIS enabled > Postgres 8.4 database. > > > > It was working fine but I am now being asked for a password for each > shapefile to load. When the correct (postgres user) password is supplied I > get the following error message; > > > > psql: FATAL: password authentication failed for user "postgres" > > FATAL: password authentication failed for user "postgres" > > > > Any help would be appreciated. > > > > Thanks. > > > > Richard. > > > > Infoterra Ltd. Is part of the Astrium GEO-Information Services Division and > a wholly owned subsidiary of Astrium, Europe's leading space systems and > services specialist. > > Disclaimer. The information contained in this e-mail and its attachments are > confidential and intended only for the use of the named addressee(s). If you > are not the intended addressee, please do not read, copy, use or disclose > this message or its attachments. If you have received this message in error, > please notify the sender immediately and delete or destroy all copies of > this message and attachments in all media. Any views or opinions expressed > are solely those of the author and do not necessarily represent those of > Infoterra Ltd and shall not form part of any binding agreement. > > Infoterra Limited a company registered in England under number 2359955 and > having its registered office at Atlas House, 41 Wembley Road, Leicester, LE3 > 1UT. VAT number GB 476 0468 27. > > P Before printing, think about the environment > > > > > > > > _______________________________________________ > 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
