Creating a New PostgreSQL Instance

Whenever a new PostgreSQL server is created on the client, you must add the server to the CommCell. To create a PostgreSQL instance, the PostgreSQL user should have DBA and SYSDBA privileges.

1. From the CommCell Browser, navigate to Client Computers | <Client>.

   Right-click PostgreSQL, point to All Tasks, and then click New PostgreSQL Instance.

2. In the Instance Name box, type the PostgreSQL instance name.

3. In the PostGres User Name box, type the user name to access the Postgres application.

   In the PostGres User Password box, type the user account password.

   In the PostGres Confirm Password box, retype the password.

4. In the Maintenance DB box, type the name of a system database which is used as Maintenance DB.

5. In the Binary Directory box, type the path to the directory where the PostgreSQL application files are stored.

   For example,

   /opt/bin

   Alternatively, click Browse to select the location.

6. In the Lib Directory box, type the path to the library directory for the instance.

   For example,

   /opt/PostgreSQL/8.4/lib

   Alternatively, click Browse to select the location.

7. In the Archive Log Directory box, type the path to the directory where you want to store the archive log files.

   For example,

   /opt/wal

   Alternatively, click Browse to select the location.

8. In the Port box, type or select the port to open the communication between PostgreSQL Server and the clients.

9. In the Log Backup Storage Policy box, select a storage policy to be used for the transaction log backup jobs under Log Backup section.

10. Click OK.