Re: [ADMIN] Win32 Postgresql Command Line Password Specification

2005-02-08 Thread John DeSoi
On Feb 8, 2005, at 3:11 AM, Andrei Bintintan wrote: I have to run some command line commands that I have to run on a windows machine. Like pgsql, dropdb, createdb etc. All these commands are runned from a php scripts.   Now, my question is how can I specify a User and Password to postgresql dat

Re: [ADMIN] Win32 Postgresql Command Line Password Specification

2005-02-08 Thread Tom Arthurs
Not sure if it will work in windows, but in unix, I use the envrionmental variable PGPASSWORD Not the safest thing in the world, but in my case, if a hacker's gotten through two layers of firewall, I'm sunk anyhow. :) Andrei Bintintan wrote: Hi, I have to run some command line commands that I h

Re: [ADMIN] Win32 Postgresql Command Line Password Specification

2005-02-08 Thread Iain
I think that's the best way to do it.   Rather than leave passwords lying around in script files, it might be best to trust a specific (specially created) user when running from a specific location on the specific database. Then you just have to keep that user account secure. I can imagine h