Configuring the PostgreSQL Database Server for remote access

Tip

This step is only needed if the database server shall accept connections from remote computers.

The section describes how to configure the PostgreSQL database server for running in corporate mode.

Start by enabling password save, as shown in APPENDIX B.

Locate the pg_hba.conf file in the data folder e.g. C:\Program Files\PostgreSQL\16\data and open it in an editor e.g. Notepad.

Info

Read about the PostgreSQL Client Authentication configuration file in the PostgreSQL online documentation.

Insert a new line to open up for all non-local connections to database as shown above.

host all all 0.0.0.0/0 md5 

Adjust spaces and save the configuration.

Restart the PostgreSQL database services to apply the update.

Configuring the Windows Firewall for remote access

This section describes how to configure the Windows firewall for MIKE OPERATIONS running in enterprise mode, where the PostgreSQL database server is installed on a separate database server.

Danger

Before configuring an inbound port rule, make sure that you understand the security impacts when configuring for remote access to the PostgreSQL database server.
Read more about network security and creating inbound port rules here.

Open the Firewall applet from the Windows Start menu on the server where the PostgreSQL database service and database is installed.

Select Inbound Rules

Click New Rule in the Actions panel to the right

Select Port

Click Next

Select TCP and Specific local ports and enter 5432 (or the port number specified when installing PostgreSQL)

Click Next

Select Allow the connection.

Click Next

Select all profiles.

Click Next

Specify a rule name – e.g. PostgreSQL (5432) – and a description.

Click Finish

The new rule is now added to the list of Inbound rules.