Changing the PostgreSQL Port Details

If the PostgreSQL server has more than once instance, each instance must use a separate port number. By default, the port number will be 5432.

Procedure

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

2. Right-click <Instance>, and then click Properties.

3. In the Port box, type or select the port number.

   • If you are using the same port number for two or more instances, you can type the port number in the IP:PORT format.

     For example: You can type the port number as 10.57.198.4:5432, if the IP for your Network Interface Card (NIC) is 10.57.198.4 and you are using port 5432. To use the same port number on a different NIC, you can type 10.57.198.5:5432.

   • If you are using the custom socket directory, enter the port in the SOCKET_DIR_PATH:PORT format.

     For example: If socket directory used is /var/run/postgresql and you are using port 5432, enter the port as /var/run/postgresql:5432.

4. Click OK.