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
