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