The first two steps are common to most Unix-based software. We start by extracting the source code, bootstrapping the build process with configure, and building it with make. We choose to install with a prefix of /usr so that Slony binaries are installed in /usr/bin. This makes executables more easily available.
Once installed, we need to ensure that our rep_user user, which we've used in the past, has PostgreSQL superuser capabilities. Slony performs many tasks that are only available to superusers, so this step is not optional. Then, we modify the postgres user's .pgpass file to allow the rep_user database user to connect from either node. While we're making user changes, we also alter pg_hba.conf on both nodes so that each ...
