Slony-I tasks
In the appropriate context, pgAdmin III can trigger several maintenance tasks.
- Restart node - Under some conditions, it may be necessary to
restart a slon process on a node, initialize as if freshly started and
make it reload its configuration. This can be triggered remotely with
the restart node function.
- Lock set - Disables updates to a set to be replicated. This is
necessary for clean switch over the source of a replication from one
node to another.
- Unlock set - Re-enables updates to a set to be replicated after a
previous lock.
- Merge set - Joins two sets, originating from the same node and
subscribed by the same nodes, into one. This can be used as a
workaround to the fact that a subscribed set can’t be extended.
- Move set - Moves a replication set from one node to another, i.e.
making the target node the new source. The old node will become
subscriber to the new provider node. This is the normal way how to
switch over gracefully the master role from one node to another.