Tom Lane wrote:
> Erik de Castro Lopo <mle+tools@mega-nerd.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
Thanks, that looks like a better solution that the PGPASSFILE.
Cheers,
Erik
--
----------------------------------------------------------------------
Erik de Castro Lopo
http://www.mega-nerd.com/