Dah, left out the port. On Fri, Apr 8, 2011 at 10:36 PM, Yang Zhang <yanghatespam@xxxxxxxxx> wrote: > 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 > -- Yang Zhang http://yz.mit.edu/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
