PostgreSQL High Availability Cookbook - Second Edition

How to do it...

As before, 192.168.56.10 is the master PostgreSQL node and 192.168.56.30 is our desired subscriber. All of the steps here should only be performed on the primary PostgreSQL server. Follow these instructions to activate Londiste on the postgres default database:

1. Extract the source code and change to the resulting directory with these commands:

        tar -xzf skytools-3.2.tar.gz
        cd skytools-3.2

2. Build and install Londiste with these commands as a root-capable user:

        export PATH=/usr/lib/postgresql/9.5/bin:/usr/pgsql-
                    9.5/bin:$PATH
        ./configure
        make
        sudo make install

3. Repeat the first two steps on the subscriber node to install necessary PostgreSQL libraries.
4. Create a file named primary.ini in the /etc/skytools directory with ...