repmgr Command—Start Replicator Manager

The repmgr command invokes the Replicator Manager, which the distributed DBA uses to administer Ingres Replicator.

To run Replicator Manager, you must have the correct system privileges and use the correct DBA name. An Ingres user with security privilege can impersonate the DBA and modify the information in Replicator Manager.

The repmgr command has the following format:

repmgr [-udba_name] [vnode::]dbname

• -udba_name

  Specifies the effective user for the session. You must run repmgr as the owner of the database.

• [vnode::]dbname

  Specifies the database to connect to. By specifying the vnode of a remote database in Replicator Manager, the DBA can administer the Ingres Replicator network from the local machine.

repmgr Example

This command, executed from a remote San Francisco computer, allows Replicator Manager to be run in client-server mode from the San Francisco computer to the hq database on the nyc node, and assumes that the San Francisco DBA is impersonating the New York DBA (nyc_dba):

repmgr –unyc_dba nyc::hq