Modifying client access configuration settings with pgAdmin
When the PostgreSQL database server is installed, it is configured to allow encrypted or non-encrypted communications from any other computer. For increased security, you can restrict access to the server by limiting the server IP addresses that can connect and by only allowing encrypted connections.
To modify connection settings:
- Stop the AX_Database service.
- Do one of the following:
-
If you are using Windows Server 2008, select .
-
If you are using Windows Server 2012, select pgAdmin III on the Start screen.
-
- Select . If you are prompted to locate the .conf file, the default location is C:\ACL\App\pgsql91\data.
- In the Backend Access Configuration Editor dialog box, double-click the entry you want to change.
- In the Client Access Configuration dialog
box enter the following information:
-
Enabled – Ensure that this checkbox is selected.
-
Type – Select hostssl if you only want to allow connections encrypted using SSL. The default value is host, which enables both encrypted and non-encrypted connections.
-
Database – Select all.
-
User – Select all.
-
IP Address – Enter the IP address, or range of IP address, you want to allow connections to the database server from. For more information on the permitted settings, see the PostgreSQL documentation.
-
Method – Select md5.
-
- Click OK.
- If you want to remove an entry, select .
- In the Backend Access Configuration Editor dialog box, select .
- Start the AX_Database service.