Connection Profile Editor

Top Previous Next

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.

Database Encoding

Sets the encoding of current database connection.

note Please note, that list that represents possible encodings consist of only one row: <default>. You may manually type in preferred value, e.g. SQL_ASCII. Or you may set all connection options and click on the Test Connect button. Then all available encodings will appear in the list.


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.

SSH Host

Sets SSH server address.

SSH Port

Sets SSH server port.

SSH User

Sets SSH server user login.

SSH Password

Sets SSH server user password.

Show password chars

This option enables showing real password chars in the SSH Password field instead of asterisks.

Use compression

Check this option to use the SSH compression, defined by the Compression Level option

Compression Level

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.

SSH Timeout

This option defines an interval of time that the Database Designer for PostgreSQL will try to connect to the SSH host.

See also:
Database Connection Manager