Re: Mutable listen_addresses GUC

Ivan Kovmir <ivan(dot)kovmir(at)cybertec(dot)at> writes:
> It is necessary to restart PostgreSQL to bind to a different network
> interface, thus breaking the active connections.

On most platforms, if you set listen_addresses to "*" then there's no
problem, the kernel will automatically cope with IP address changes.
Do we really need more than that?

The reason I'm pushing back is that this patch looks extremely
complicated and hard-to-test. It also violates one of the fundamental
precepts of the GUC subsystem, namely that assign hooks shalt not
fail. And there is a lot of stuff you've not covered, such as the
logic around whether to register for Bonjour. We could possibly
make this feature work, but the cost-benefit ratio looks quite poor.

regards, tom lane