Re: BUG #8586: Misleading fe_sendauth error message

Erik de Castro Lopo <mle+tools(at)mega-nerd(dot)com> writes:
> I haven't read the code, but my guess is that psql does the following:

> a) Grabs the user and database name from command line.
> b) Looks up dbname in pgpassfile to get host and port number etc.
> c) Connects to host:port and uses supplied username/password.

No, you are mistaken. The .pgpass file provides a password given
a user/dbname/host/port to be connected to. It is not the source
of any data other than the password.

You might want to look into the "service file" feature, which does
allow various connection parameters to be provided from a single name.

http://www.postgresql.org/docs/9.3/static/libpq-pgservice.html

regards, tom lane