PostgreSQL Maestro online Help

Return to chapter overview

Setting connection properties

The first wizard step allows you to set connection properties for the new database.

PostgreSQL Maestro allows you to connect to PostgreSQL servers directly or via Secure SHell (SSH) tunnel.

•	Direct connection is the most preferable connection mode.

•	If your PostgreSQL server does not allow direct connections from remote workstations, you can establish connection to intermediate SSH server and forward all PostgreSQL commands through the Secure SHell (SSH) tunnel.

•	HTTP tunneling is a technique used in conditions of restricted network connectivity including firewalled networks, networks behind proxy servers, and NATs. It is the slowest way and is recommended to use if the others are impossible.

Irrespectively of a connection mode you should specify common credentials as follows:

Host

The host name of the PostgreSQL server.

Port number

The TCP/IP port to use if server is not localhost.

User name

The username used to connect to PostgreSQL.

Password

The password for the user account on server.

To establish connection to intermediate SSH server and forward all PostgreSQL commands through the secure tunnel, you need to:

1.	Check I can connect to the server directly or via SSH tunneling.

2.	Use Configure SSH options to open the SSH Options window.

3.	Check Connect through the Secure Shell (SSH) tunnel and specify the following SSH connection properties.

Host name

Specify the host name or IP of your site.

Port number

Set the SSH server port number.

Enter valid User name and Password to log in to the remote server.

Note: 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.

To connect to a remote server using a PHP script, you need to:

1.	Upload the connection PHP script to your website. The script is named pgsql_tunnel.php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\PostgreSQL Maestro.

2.	Select the I have to use HTTP tunneling radio button.

Enter the connection PHP script URL, e.g. www.yoursite.com/files/pgsql_tunnel.php. You can test the connection before the profile is created. Just use Test script using default browser to open connection script in your browser, enter all the required connection parameters and use the Test connection button.

4.	In case using of a proxy server use Configure proxy server to open the Proxy server options window and specify your proxy server connection parameters.

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

Check the Create profile after creating the database option to open the Edit Database Profile dialog after the new database is created.