Re: Why do we have a database specification in .pgpass?

Dennis Björklund <db@zigo.dhs.org>

From: Dennis Björklund <db@zigo.dhs.org>
To: "Bruce Momjian" <bruce@momjian.us>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-10-14T04:09:35Z
Lists: pgsql-hackers
> We have a database specification in .pgpass:
>
> 	hostname:port:database:username:password
>
> What is the purpose of 'database' since username/password combinations
> are global, not per database?  I would like to documents its purpose.

There is the GUC parameter db_user_namespace. Just for that you could
probably  use dennis@foo as username instead, so maybe it's not the
purpose. But I can't think of any other reason.

/Dennis