The following table describes the PostgreSQL mirroring parameters worksheet when building or copying a database. You need these values when you set up a mirror database.
Parameter |
Description |
---|---|
Host Interface Name |
Defines the name of the host computer for the mirror PostgreSQL database server. The host name must have a valid IP address. |
Port Number |
Specifies the communications port on which the mirror PostgreSQL database server listens for queries. If you use PostgreSQL database Server for the mirror database, you must log in to this server. The Port Number can be found in the <PostgreSQL Home> pgsql/etc/pg_service.conf file. Refresh Type: Recycle |
Database Owner (DBO) |
Defines the name of the Control‑M/Server Mirror database owner. Control-M uses the name when accessing the mirror database. When building a new mirror database, the initialization script creates this user on the database server. After using this utility, enter the DBO password to access the Control-M/Server database. NOTE: Limited to 30 alphanumeric characters (including underscores). Do not use upper-case letters. |
Database Owner Password |
Defines the password for the Control‑M Mirror database owner. The characters you enter do not copy for security reasons. Control‑M processes and utilities use the password to access the mirror database. NOTE: Use 6 to 30 alphanumeric characters, but the symbol, ', is not permitted. |
Database Administrator Password |
Defines the password of the mirror PostgreSQL database server administrator. The characters you enter do not echo for security reasons. |
Database Name |
Defines the name for the Control‑M/Server Mirror database. This name must be unique within the mirror PostgreSQL database server.
|
Database Location |
Defines the location of the Control‑M/Server Mirror database owner. NOTE: You must create this location prior to installing the Control-M/Server mirror database. The location must be empty. This is only relevant when the PostgreSQL database, which uses the mirror database, is located on UNIX. The recommended location should be an empty directory under <owner user home directory>/pgsql. |
Existing Database |
Valid values:
|
Mirror Retry
|
Defines the number of retries the Control-M/Server will attempt before marking the mirror as damaged. Valid values are 0-99 seconds. Default: 10 seconds |
Encoding: (default: LATIN1) |
LATIN1, UTF8 |
Parent Topic |