On 2013-12-11 08:56:43 -0500, Robert Haas wrote: > > $ psql -d "hostaddr=127.0.0.1" > > =# \conninfo > > You are connected to database "postgres" as user "postgres" via socket > > in "/tmp" at port "5432". > > Yeah, that's true. But the whole point of having both host and > hostaddr seems to be that you can lie about where you're connecting. > If you set host=some.pretty.domain.name hostaddr=1.2.3.4, the point is > to say that you're connecting to the first while, under the covers, > actually connecting to the second. Now, I am unclear what value this > has, but someone at some point evidently thought it was a good idea, > so we need to be careful about changing it.
One use case is accessing a particular host when using DNS round robin to standbys in combination with SSL. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers