Ashish Karalkar wrote: > Hello All, > > I am trying tu run a script to create database from a batch programme > and dont want to supply password everytime. > So i tried to setup pgpass.conf file. > File is kept in user profile/application data > i.e > C:\Documents and Settings\postgres\Application Data\postgresql\pgpass.conf > > file contains: > > localhost:5432 :*:postgres:mypass > localhost:5432:qsweb:qsweb:mypass1 > > Still the batch asks for the password.!!! > I am just not getting why its not reading password from pgpass file. > > can anyone please figure out what is going wrong. Under what user account is the batch file being run? The pgpass.conf file needs to be under *that* user account, which is not necessarily the one that the postgresql server runs under. Regards, Dave