[postgis-users] Re: shp2pgsql

[Paul Ramsey]

The problem is in the "psql -d disasterdb" part, you are failing to  
login, so it is not a postgis problem per se.  Why don't you do away  
with local passwords altogether?  Under the PostgreSQL menu in your  
Windows menu you'll find one option to "edit pg_hba.conf".  Use that,  
go to the bottom of the file, and change the entry for "local" from  
"password" (or whatever it is) to "trust".

P

On 22-Feb-06, at 12:07 AM, indrajit11 at indosat.net.id wrote:

>
>
> ----Original Message----
> From: indrajit11 at indosat.net.id
> Date: Feb 22, 2006 14:31
> To: <postgis-users at postgis.refractions.net>
> Subj: shp2pgsql
>
> Hi All!
>
> Please help me on this..
>
> I am absolutely new to postgis, but I have problem (it's seems too
> early for a problem to come)
> My specs are:XP  environment, using postgresql 8.1 for windows and
> I've installed postgresql and postgis in ntfs hard drive.
>
> I want to upload shapefile data into postgresql database using postgis
> loader (shp2pgsql)
> by typing in command prompt with default postgres login (xp login):
>
> " shp2pgsql d:\tsunami_prone.shp public.ts_prone | psql -d disasterdb"
>
> but I've error message
> "psql: FATAL: password authentication failed for "postgres"
>
> could anybody give me solution.
>
> thanks
>
>