PostgreSQL Maestro online Help
|Prev||Return to chapter overview||Next|
PostgreSQL Maestro allows you to connect to PostgreSQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.
It is the most natural and the most preferable connection mode. Use it each time it is possible.
|•||SSH tunnel connection|
If your PostgreSQL server does not allow direct connections from your remote workstations, you can establish connection to an allowed intermediate SSH server and forward all PostgreSQL commands through the Secure SHell (SSH) tunnel.
To establish connection to intermediate SSH server and forward all PostgreSQL commands through the secure tunnel, you need to:
Specify the host name or IP of your site.
Enter the port number for the SSH server.
Enter valid User name for the remote server, select the authentication type: by password or by private key and set the Password or the path to the Private key file with the corresponding Passphrase 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.
|•||HTTP tunnel connection|
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.
To connect to a remote server using an HTTP tunnel, you need to:
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.
Irrespectively of a connection mode you should specify common credentials as follows:
The host name of the PostgreSQL server.
The TCP/IP port to use if server is not localhost.
The username used to connect to PostgreSQL.
The password for the user account on server.