> I'm using postgreSQL 8.2.5 for Windows (with postGIS) and MapServer for > Windows for development environment. They run on Windows XP. > > I just reformatted the hard drive and re-installed everything (postGIS, > ms4w), etc. Then, my first step is reloading all the development shapefiles > (SHP) into postGIS database using shp2pgsql.exe (to create the script) and > psql.exe (to run the script and load the data). > > The psql.exe command doesn't specify password, and it is something like this: > psql.exe -c -d mydatabase -h localhost -U myuser -f > "D:\mapfiles\scripts\myloadingscript.sql" > > When I ran the command above, it prompts me for a password. No wonder, > because the script doesn't specify the password. > > However, the script above did NOT prompt for a password before I reformatted > my hard drive. Thus, I have disabled postgreSQL password in my previous > setting. > > Alas, I don't remember what should I do to disable password. I have given > public access to my spatial database, and the psql.exe still prompts for a > password. > > I really don't remember what I did previously to my postgreSQL (before > reformatting). I can only remember that the data loading script above never > asked for password before I reformatted my hard drive. > > Anyone could please help? Many thanks, > -Kresh >
Hi Kresh, Edit the pg_hba.conf file and change the METHOD column to the trust mode, something like: local all all trust (you may configure other parts to set databases and users that are allowed to connect to the DB with trust mode). Nicolas _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
