The Connection Profile Editor allows you to set up the database connection parameters and other additional preferences. It can be launched during the process of a new profile creation and also can be used through the Database Connection Manager.
The Profile Editor consists of several tabs. Please see the detailed description below.
The Connection tab allows you to define the PostgreSQL server connection parameters and select the required database.
Sets PostgreSQL server address.
Sets PostgreSQL server port.
Sets PostgreSQL server user login.
Sets PostgreSQL server user password.
Show password chars
This option enables showing real password chars instead of asterisks in the Password field.
This option defines the time interval for the Database Designer for PostgreSQL to connect to the PostgreSQL database.
Sets the encoding of current database connection.
Selects a database from the list of the ones, which are available on the server.
The following options are used to establish secure SSL connection.
Use SSL Connection
Enable SSL connection.
SSL Client Certificate
Allows to select the file containing the client certificate.
SSL Private key
Allows to select the file containing the client private key.
Connecting through SSH tunnel gives you two main advantages:
1. You can connect to PostgreSQL server even if the direct connections to it are not allowed. It's a typical situation on a shared hosting.
2. The traffic between the server and Database Designer for PostgreSQL is secured.
If you set the SSH tunnel, this may request you to change the settings in the Connection tab: imagine that your current computer is the server you set the SSH tunnel with. So, perhaps you will have to change the value of the Host field to localhost.
Please note, that using SSH tunnel requires SSH service available on server you are connecting with.
The SSH tab allows you to establish connection to PostgreSQL using secure SSH tunneling. To connect to PostgreSQL through SSH check the Enable SSH Tunneling option and specify the SSH connection parameters.
Sets SSH server address.
Sets SSH server port.
Sets SSH server user login.
Sets SSH server user password.
Show password chars
This option enables showing real password chars in the SSH Password field instead of asterisks.
Check this option to use the SSH compression, defined by the Compression Level option
Set Compression to any value between 1 and 9 (1 for minimum compression, 9 for maximum compression). Typically, SSH clients use compression level 6 for optimum performance.
This option defines an interval of time that the Database Designer for PostgreSQL will try to connect to the SSH host.