Re: fix psql \conninfo & \connect when using hostaddr

Fabien COELHO <coelho@cri.ensmp.fr>

From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Noah Misch <noah@leadboat.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, Arthur Zakirov <a.zakirov@postgrespro.ru>, Robert Haas <robertmhaas@gmail.com>
Date: 2019-06-11T04:46:41Z
Lists: pgsql-hackers
Hello Dmitry,

> Given that it's an open item for PostgreSQL 12,

I'm working on it, but slowly.

> I've decided to take a look.

Thanks!

> Indeed, looks like 6e5f8d4 introduced a subtle behaviour change, when 
> hostaddr changes are not picked up for subsequent \connect's, and I 
> don't see any mentions of it in the documentation.

ISTM that the documentation is kind of fuzzy enough to match both
behaviors.

> Although I guess it can be avoided by `-reuse-previous=off`, probably it 
> makese sense to update the docs.

Yep, that is one option. The other is to revert or alter the subtle 
change, but ISTM that it made sense in some use case, so I wanted some 
time to think about it and test.

-- 
Fabien.



Commits

  1. Tweak libpq's PQhost, PQhostaddr, and psql's \connect

  2. psql: Show IP address in \conninfo