SQL Maestro Group / Products / PostgreSQL / PostgreSQL Data Wizard / Documentation

PostgreSQL Data Wizard online Help

Setting connection properties

Set the connection properties in the respective boxes: user name, port number, and password to connect to PostgreSQL server you need.

Use the Test Connect button to test the connection properties you have specified. The operation will return a message box with the operation result.

Select the database from the drop-down list or type the database name manually and use the Next button or press the Enter key.

You can also specify a custom connection string.

Latest versions of Data Wizard for MySQL, PostgreSQL Data Wizard and SQLite Data Wizard allow you to connect to a database directly, or via Secure Shell (SSH) tunnel, or using HTTP tunnel. On the database profile creation you should firstly select the way of the connection.

Direct connection

Just set the connection properties in the respective boxes: host, user, database, etc.

SSH tunnel connection

To establish connection to intermediate SSH server and forward all PostgreSQL commands through the secure tunnel, check the corresponding radio button, set connection properties as indicated above for direct connection, and use Configure SSH options link to open SSH Options window. Check the Connect through the Secure Shell (SSH) tunnel option and type the SSH connection properties in the respective boxes there.

Note that PostgreSQL host name always should be set relatively to the SSH server. For example, if both of PostgreSQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.

HTTP tunnel connection (The slowest way. It's recommended to use the connection mode if the others are impossible.)

Note: To connect to remote PostgreSQL in this way, you should first of all upload the <> script to the destination site. The script can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\PostgreSQL Data Wizard.

To connect to a remote server using a PHP script, select I have to use HTTP tunneling radio button, enter the script URL, and specify database connection properties as indicated above for direct connection. In case using of a proxy server use Configure proxy server link to open Proxy server options window and specify the proxy server connection parameters.

Note: You are actually connecting to MySQL through the PHP script on the server, so in most cases the host/server name is "localhost" unless the MySQL server is not installed on the same server as the Web server.

You can test the connection before the profile is created. Just use test script using default browser link to open connection script in your browser, enter the connection information (host, user, password, port), and database name and use Test connection button. Click Get Database List to view available databases.

Return to chapter overview