PostgreSQL mirroring parameters

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.

  • When building a new mirror database, the initialization script creates this database on the database server.
  • When copying to an existing database, this database must already be defined on the database server.

    NOTE: Do not use upper-case letters.

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:

  • Y: This value indicates that the Control-M/Server database is defined on a remote PostgreSQL database server.
  • N: This value indicates that the Control-M/Server database is defined on the local PostgreSQL database server.

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

Mirroring parameters