[postgis-users] PostGIS shp2pgsql load problem

[Richard White]

Hi,

Thanks for your help. I have modified the pg_hba.conf file and all works well now.

Regards,

Richard.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Nicolas Ribot
Sent: 14 November 2011 15:38
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS shp2pgsql load problem

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.
>
>
>
>
>
>
>
> _______________________________________________
> 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

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