[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Re: shp2pgsql
From:       Paul Ramsey <pramsey () refractions ! net>
Date:       2006-02-22 15:17:15
Message-ID: 4DB2CBB7-07ED-4454-B63B-758D77511F77 () refractions ! net
[Download RAW message or body]

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@indosat.net.id wrote:

>
>
> ----Original Message----
> From: indrajit11@indosat.net.id
> Date: Feb 22, 2006 14:31
> To: <postgis-users@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
>
>


[prev in list] [next in list] [prev in thread] [next in thread]