PostgreSQL parameters

The following table lists the Control‑M/Server database parameters for the PostgreSQL environment.

Parameter

Description

Host Interface Name

Defines the host name of the machine where the PostgreSQL Server resides. If you install the dedicated PostgreSQL Server, the value is the current machine. For a silent installation, the value of this parameter is blank, and the installation procedure uses the name of the current machine.

Port Number

Defines the TCP/IP port for communication between Control‑M/Server and the PostgreSQL Server. If this port number is already used by an existing application, choose another value, in the range 1024 to 65534 inclusive.

Default: 5432

Refresh Type: Recycle

Database Administrator (postgres) Password

Defines the password for the database administrator (user postgres). The characters you enter do not echo for security reasons. Control‑M/Server utilities uses the password to access restricted sections of the Control‑M/Server database.

NOTE: The single apostrophe symbol (" ‘ ") is not permitted for PostgreSQL.

Control‑M/Server Database Name

Defines the name of the Control‑M/Server database. This name must be unique, and contain up to 30 alphanumeric lowercase characters (including the underscore character).

Control‑M/Server Database Owner

Defines the database name for the Control‑M/Server database owner. The installation script creates this user in the database. Control‑M/Server uses this when accessing its database.

If you use unique values for owner name, database name, and device assignments, a new database is built on the server. By using an existing owner name, database name, and device assignment, you delete and recreate the database elements.

Every computer type uses a different character set for the server.

Control‑M/Server Database Owner (DBO) Password

Defines the password for the Control‑M/Server database owner. This name must be unique, and must contain up to 30 alphanumeric lowercase characters (including the underscore character). The characters you enter do not echo for security reasons. Control‑M/Server processes and utilities use the password to access the Control‑M/Server database.

NOTE: The single apostrophe symbol (" ‘ ") is not permitted for PostgreSQL.

Database Scalability

Defines the amount of resources in the operating system of the computer on which the PostgreSQL server is employed.

Valid values:

  • Small
  • Medium
  • Large

Database Server Home Directory (Windows only)

Defines the full path name of the location where the PostgreSQL database server resides: <Control-M/Server path>/pgsql.

NOTE: Only for PostgreSQL database server on Windows.

Database Location (UNIX only)

Defines the full path name of the location in which the Control-M/Server database should be installed: $PGHOME

You must create this location prior to installing the Control-M/Server database.

NOTE: Only for PostgreSQL database server on UNIX.

Parent Topic

Database parameters