Slony-I administration with pgAdmin III: installation

Prerequisites

As a prerequisite to running Slony-I on PostgreSQL, the slony modules xxid and slony1_funcs must be present on all servers that have to run a Slony-I replication node. This is usually done by the Slony-I installation routine.

Overview

Setting up Slony-I for the first time can be a daunting task. The following sections of the pgAdmin helpfile will help guide you through creation of your first cluster.

  • Step 1: Create the cluster on the master node.

  • Step 2: Add slave nodes to the cluster.

  • Step 3: Setup paths on each node to all other nodes.

  • Step 4: Setup listens on each node to all other nodes (Note: Not required with Slony-I v1.1 or later).

  • Step 5: Create a replication set.

  • Step 6: Add tables and sequences to the set.

  • Step 7: Subscribe the slaves to the set.

Note At this point, the slon daemons (service engines on Windows) should be started.

Create cluster and first node

_images/slony-create.png