PostgreSQL Create Instance

Updated

Use this dialog box to define a new instance or view the properties of an existing instance.

Server Name

Use this space to specify the name of PostgreSQL Server

PostGres User Name

Displays the name of the PostgreSQL database user who has permissions to perform jobs. Use this space to change this name.

PostGres Account Password

Displays the password for the User Name. Use this space to change this password.

PostGres Confirm Password

Retype the Account Password to confirm it.

Maintenance DB

Specify the name of system database which is used as maintenance db.

Binary Directory

Displays the path of the binary directory for the instance. Click Browse to change this path.

Lib Directory

Displays the path of the Library directory for the instance. Click Browse to change this path.

Archive Log Directory

Displays the path of the archive log directory for the instance. Click Browse to change this path.

Note: On a Windows client, if Archive Log Directory is configured as a UNC path, set the value for bAllowUNCForPostgres to true. If you type a UNC path, click Change to provide UNC user account credentials.

For instructions on adding the additional setting from the CommCell Console, see Add or Modify an Additional Setting.

Port

Select the port to open the communication between PostgreSQL Server and Clients.

Log Backup

Specifies the storage policy to be used in transaction log backup jobs for the instance.

Log Backup Storage Policy

Select from the list of available storage policies that can be used in transaction log backup jobs for the instance.

Archive Delete

When selected, the archived log backup files will be deleted.

Description

Use this field to enter a description about the entity. This description can include information about the entity's content, cautionary notes, and so on.

Was this page helpful?