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.
Connection
The Connection tab allows you to define the PostgreSQL server connection parameters and select the required database.
Host
Sets PostgreSQL server address.
Port
Sets PostgreSQL server port.
User
Sets PostgreSQL server user login.
Password
Sets PostgreSQL server user password.
Show password chars
This option enables showing real password chars instead of asterisks in the Password field.
Timeout
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.
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.
Database
Selects a database from the list of the ones, which are available on the server.
SSL
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.
SSH
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