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