Managing the database on PostgreSQL

Configure client access, change the connection settings, move, or backup and restore the PostgreSQL database server.

Administration tools

You can administrate PostgreSQL using the following tools:

• command line executable
• pgAdmin GUI

Connect to the PostgreSQL instance using pgAdmin

Access the database server locally or remotely using pgAdmin. Local connection information is configured during installation.

1. From your operating system's Start menu, open the pgAdmin administrative tool.
2. From the menu, select File > Add Server and in the New Server Registration dialog box, enter the following information:
   • Name the name for the server connection
   • Host the IP address of the server where PostgreSQL is installed
   • Maintenance DB AclAuditExchangeDB
   • Username the username for the ACL GRC Analytics Exchange database user specified during installation. The default value is AclAuditExchangeRole
   • Password the password for the ACL GRC Analytics Exchange database user specified during installation
3. Click OK.

Change the PostgreSQL database password using pgAdmin

1. In pgAdmin, connect to the AclAuditExchangeDB database using the Superuser account.

   The default account name is postgres.

2. In the Object browser, expand the Login Roles sub-folder, right-click the database user account, and select Properties.
3. In the Password field, enter the new password, re-enter it in the Password (again) field, and then click OK.
4. To allow ACL GRC Analytics Exchange applications to continue to connect to the database, on each server that hosts the TomEE application server, update the information in the aclDatabase.xml configuration file.

   For more information, see aclDatabase.xml.

Enable SSL connections using pgAdmin

1. Stop the AX_Database service and open pgAdmin.
2. From the menu, select File > Open postgresql.conf.

   The default location of the configuration file is c:\ACL\App\pgsql93\data.

3. In the Backend Configuration Editor dialog box, from the Setting name list, select ssl and make the following changes:
   • Select Enabled.
   • In the Value field, enter on.
   • Click OK.
4. In the Backend Configuration Editor dialog box, click File > Save.
5. Start the AX_Database service.

[ Back to top ]