[postgis-users] PostGIS shp2pgsql load problem

[Nicolas Ribot]

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
<Richard.White at infoterra-global.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>