----- Original Message -----
From: "Dave Page" <dpage@xxxxxxxxxxxxxx>
To: "Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, July 10, 2007 4:25 PM
Subject: Re: [GENERAL] pgpass.conf
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
The batch file is run under postgres user, also owner of the pgpass.conf
file is postgres.
As far as my knowledge the permission checking is not done on windows
anyways the owner is same so i dont think there is any problem of permission
from pg documents:
"The permissions on .pgpass must disallow any access to world or group;
achieve this by the command chmod 0600 ~/.pgpass. If the permissions are
less strict than this, the file will be ignored. (The file permissions are
not currently checked on Microsoft Windows, however.)"
