Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
Ashish Karalkar wrote: > 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 > OK - have you tried 127.

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Magnus Hagander
On Tue, Jul 10, 2007 at 04:34:56PM +0530, 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

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Ashish Karalkar
- Original Message - From: "Dave Page" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Cc: 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

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
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\Applicatio

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Raymond O'Donnell
On 10/07/2007 11:28, Ashish Karalkar wrote: I have set this succesfully on redhat linux but iam messed up in Windows XP prof. Is there any other thing to do? I'm not a guru, but maybe it's a permissions problem on the pgpass file? Ray. -

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Ashish Karalkar
- Original Message - From: "Raymond O'Donnell" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, July 10, 2007 3:51 PM Subject: Re: [GENERAL] pgpass.conf On 10/07/2007 08:47, Ashish Karalkar wrote: Still the

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Raymond O'Donnell
On 10/07/2007 08:47, Ashish Karalkar wrote: Still the batch asks for the password.!!! I am just not getting why its not reading password from pgpass file. Probably a silly question, but if you're using the createdb utility in the batch file, have you inadvertently included the -W option? - t

Re: [GENERAL] PGPASS.CONF ¿is there a way to p

2007-01-09 Thread Magnus Hagander
guillermo arias wrote: > Hello, i am using PostgreSQL 8.2 in a Windows XP pc. I know that this > file PGPASS.CONF stores the users with password, but because this is a > plain txt file, it is easy for "curious" people to read the contents. > By other way, if i do not write the password there, my us