Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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.


Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform

How to configure Replication Manager (repmgr) ?

Script to kill ALL IDLE Connection In postgreSQL