To configure the connection to your PostgreSQL Server databases, select PostgreSQL Server (TCP/IP) as your server type.

Required minimum settings

In the opened window, specify:

1. Your server’s name
2. Port, if it differs from the default port 5432
3. User name and password

These are the basic minimum settings. Once they are ready, you can test the connection and save the settings.

Advanced connection settings

For more specific settings go to Advanced settings, where you can set:

1. Default database name
2. SSL Mode
3. Path to PostgreSQL bin folder. Specify the path to the PostgreSQL bin folders in case you encounter version compatibility issues for example, “C:\Program Files\PostgreSQL\16\bin.”
4. The way the password will be passed can be either via environment variables or via a password file.

Connect using SSH tunnel

If an SSH tunnel is required for the connection enable the Connect using SSH tunnel option in the advanced settings and specify:

1. Your hostname
2. SSH port
3. Local mapped port
4. User name
5. Choose the authentication method which can be either a password or a key file
6. Enter the password or specify the path to where the key file is located

After configuring the settings, you can test the connection and save the settings.

Info button

If you click the “info” button in the connection settings, you will see the command used to connect to the database. If you encounter connection issues, you can manually execute this command via the command line to diagnose the problem.