Re: .pgpass not working?

Dah, left out the port.

On Fri, Apr 8, 2011 at 10:36 PM, Yang Zhang <yanghatespam(at)gmail(dot)com> 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/