Installing Slony Replication on a Debian or Ubuntu Host v2.2.10

You must install EDB Postgres Advanced Server before installing Slony Replication. For details about installing and configuring EDB Postgres Advanced Server, see the EDB Postgres Advanced Server Installation Guide available at the EDB website. To install Slony Replication on a Debian or Ubuntu host, you must have credentials to access the EnterpriseDB repository. If you need EnterpriseDB credentials, visit the EDB website.

The following steps will walk you through using the EnterpriseDB repository to install a DEB package. When using the commands, replace the username and password with the credentials provided by EnterpriseDB.

  1. Assume superuser privileges:

    sudo su –
  2. Configure the EnterpriseDB repository:

    On Debian 9, Ubuntu 18 and Ubuntu 20:

    sh -c 'echo "deb$(lsb_release -cs)-edb/ $(lsb_release -cs) main" > /etc/apt/sources.list.d/edb-$(lsb_release -cs).list'

    On Debian 10:

    a. Set up the EnterpriseDB repository:

    sh -c 'echo "deb [arch=amd64]$(lsb_release -cs)-edb/ $(lsb_release -cs) main" > /etc/apt/sources.list.d/edb-$(lsb_release -cs).list'

    b. Substitute your EnterpriseDB credentials for the username and password placeholders in the following command:

    sh -c 'echo "machine login <username> password <password>" > /etc/apt/auth.conf.d/edb.conf'
  3. Add support to your system for secure APT repositories:

    apt-get install apt-transport-https
  4. Add the EDB signing key:

    wget -q -O -  | sudo apt-key add -
  5. Update the repository metadata:

    apt-get update
  6. Install the Debian package:

    apt-get -y install edb-as<xx>-slony-replication

    where <xx> is the EDB Postgres Advanced Server version.

    For example, to install Slony Replication for EDB Postgres Advanced Server version 13, execute the following command:

    apt-get -y install edb-as13-slony-replication

    The following table lists the path of the service, installation, and configuration path.

Service File PathInstallation File PathConfiguration File Path
/lib/systemd/system/edb-as<xx>-slony-replication.service/usr/lib/edb-as/<xx>The configuration file named slony-replication.ini is located in /etc/edb/slony-replication<xx>

Where <xx> represents the EDB Postgres Advanced Server version.