EMS logo

Products Navigation

SQL Query for PostgreSQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for PostgreSQL

On-line Documentation

Setting connection properties


Enter the necessary settings to establish connection to PostgreSQL server.

 

hs3221 - Specifying the host

 

 

 

Host name

Type in, or use the drop-down list to specify the host name of the PostgreSQL server.

 

You should enter PostgreSQL port to connect through in the Port field ('5432' is default).

 

Afterwards you should specify authorization settings: User name and Password. The default superuser name is 'postgres' with the password specified during PostgreSQL server installation.

 

CheckBox Register a single database

Check this option if you wish to register one database or leave it unchecked if you wish to register several databases at the host.

 

CheckBox Use  Tunneling

If this option is checked, you should set tunneling parameters at the Specifying tunneling parameters step of the wizard.

 

RadioButton SSH tunneling

Select this option to establish connection to an intermediate SSH server and forward all PostgreSQL commands through the secure tunnel. The next step of the wizard allows you to define the corresponding parameters for SSH tunneling.

 

RadioButton HTTP tunneling

Select this option to access PostgreSQL server through the HTTP protocol in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to PostgreSQL, but allows HTTP connections. The next step of the wizard allows you to define the corresponding parameters for HTTP tunneling.

 

Click the Next button to proceed to the Setting registration options step of the wizard, or to the Specifying tunneling parameters step (if SSH tunneling or HTTP tunneling is used).