On 2019-11-28 18:02, Christoph Berg wrote:
Not sure if there's a way around that, certainly not with TLS connections (but that doesn't work without systemd either). Possibly moving the connections to a helper process first, and then exec()ing to the new version, and moving the connections back to the original PID would work.
It might be possible to do this if we have systemd organize the file descriptor passing (using socket activation and all that). It's something I've been meaning to look into, but it would be a development effort, not just a packaging change.
Another option might be to use the SO_REUSEPORT socket option and start a new pgbouncer instance concurrently with the old one. Then you can shut down the old one once the new one is up and taking on connections. I don't know whether that's in scope for packaging, either, though.
