PostgreSQL High Availability Cookbook - Second Edition

How to do it...

For these instructions, 192.168.56.10 is the master PostgreSQL node, and 192.168.56.30 is our desired subscriber. Follow these instructions to activate Slony on the postgres default database:

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

        tar -xjf slony1-2.2.5.tar.bz2
        cd slony1-2.2.5

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

        ./configure --prefix=/usr
        make
        sudo make install

3. Repeat the above two steps on the subscriber node to ensure necessary libraries are available to Slony.
4. Provide the rep_user database user with superuser capabilities by running this SQL statement on both PostgreSQL nodes:

        ALTER USER rep_user WITH SUPERUSER;

5. Enter the following line ...