PostgreSQL

Connection Details

Server

This field should contain the hostname or IP address of the PostgreSQL server. If the database is hosted on the same machine as the client, 'localhost' can be used.

Port

PostgreSQL default port is 5432. This field should match the port configuration of your PostgreSQL server.

Username

Enter the username for the PostgreSQL account that has the necessary privileges to access the database.

Password

The associated password for the given username.

Database

Specify the PostgreSQL database name to which you wish to connect. You can either type the database name directly or use the 'Select' button to choose from a list of available databases, provided the connection details above are correctly filled out and the client can communicate with the server.

Encryption

Indicate whether your connection should be encrypted. If your PostgreSQL server is configured to require SSL connections, select 'Encrypted'; otherwise, select 'Not encrypted'.