Online Documentation for SQL Query for PostgreSQL
Setting connection properties
Enter the necessary settings to establish connection to PostgreSQL server.
Type in, or use the drop-down list to specify the host name of the PostgreSQL server.
For both types 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.
Register a single database
Check this option if you wish to register one database at the host.
If this option is checked, you should set tunneling parameters at the Specifying tunneling parameters step of the wizard.
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.
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.
If the Register a single database option has been unchecked, you should also specify the databases you wish to be registered at the host. To select a database, you need to move it from the Available databases list to the Selected databases list. Use the buttons or drag-and-drop operations to move the databases from one list to another.