PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

Only Debian variants are supplied with a systemd-compatible service control file, mainly because it is adapted from the deprecated /etc/init.d/slony1 file included with the package. As a consequence, we chose to start Slony manually to demonstrate how this is done. On Debian systems, you can do this instead:

sudo systemctl enable slony1
sudo systemctl start slony1

We're not quite sure why the PGDG packagers of Red Hat and CentOS don't include a similar file for these distributions but suspect it's partially due to the fact Slony itself has been deigned a historic curiosity. Indeed, we'll soon learn that all trigger-based replication systems are considered antiquities.