I'm using the postgresql 8.4.7 in Ubuntu 10.04, and I'm trying to use .pgpass documented here:
http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html I have a ~/.pgpass with 600 perms containing: myhostname.com:yang:yang:mypassword However, it doesn't seem to get picked up by psql -h myhostname.com. I also tried explicitly specifying PGPASSFILE, but that didn't work. Neither that env var nor .pgpass is documented in man psql. Entering my password manually works, however. (Don't need to specify username/database since they default to my username, which is also yang.) Also tried connecting with psycopg2 via sqlalchemy (connect string "postgresql://myhostname.com/yang"), and it also didn't auto pick up .pgpass. Any hints on what's up? Thanks in advance. Yang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
