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 database system. I found out how can I say the user, but the password is always asked in the command line. I need this also to be specified in the command.
The recommended method is to use the pgpass.conf file on Windows:
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
There is also a PGPASSWORD environment variable, but this is depreciated for security reasons.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
