Hi Michael!
man pages of psql 7.4.7 mentions PGUSER, but not PGPASSWORD. Maybe this
was replaced with the ~/.pgpass file
regards
klaus
Michael Ulitskiy wrote:
As far as I know this is not true.
username and passwords can be supplied to postgres via environment
variables: PGUSER and PGPASSWORD
Michael
On Friday 16 December 2005 03:06 am, Klaus Darilion wrote:
Bogdan-Andrei Iancu wrote:
Hi Klaus,
when I applied Norman's fix regarding the PW env. variable in
mysqldb.sh, I wanted to update also the postgres script, but I saw it
commented out - any reasons not for providing passwd to postgres? it
will be a nice to be able to pass the password via env. without being ask.
Hi Bogdan!
psql works different than mysql. You can not provide the password like
it is done for mysql. For automatic login with psql you have to use a
.pgpass file in your home directory.
http://pgsqld.active-venture.com/libpq-files.html
e.g. I have in /home/darilion/.pgpass:
localhost:*:*:openser:openserrw
localhost:*:*:openserro:openserro
file access rights must be 0600:
-rw------- 1 darilion darilion 159 Aug 4 18:07 .pgpass
otherwise psql does not accept the .pgpass file
regards
klaus
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
