[postgis-users] How to disable password in postgreSQL (pardon the stupid question)

[Nicolas Ribot]

> 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