PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

All of these socat commands are highly cumbersome since they require pipes and the physical location of the command socket. Thankfully, there is a nonstandard utility named haproxyctl that simplifies many of these operations. Debian derivatives should have access to this within standard repositories, but Red-Hat-related systems may need to visit the Git repository.

However it is obtained, this utility transforms the management of HAProxy into something that's much easier to understand and perform:

haproxyctl disable server bk_db/bdr_chicago haproxyctl enable server bk_db/bdr_chicago

We definitely feel that this is a major improvement! We only wish all Linux distributions packaged it as readily as HAProxy, or that the HAProxy ...