PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

Luckily, PostgreSQL provides most of the tools we need. However, there is a more advanced command-line utility named tcpkill that we may need to use later. If it's not already installed, we recommend that you do so before continuing. Debian or Ubuntu-based systems can use this command as a root-capable user:

sudo apt-get install dsniff

For lucky users of 9.6 and above, we suggest setting the new idle_in_transaction_session_timeout parameter to 3600 or lower in postgresql.conf. This parameter will tell PostgreSQL to automatically cut any connection that is idle for longer than an hour.