What Is HTTP Tunnel?
HTTP Tunneling is a method for connecting to a PostgreSQL
server that uses the same protocol (http://) and the same
port (port 80) as a webserver does. It is used while your
ISPs do not allow direct connections to their PostgreSQL server,
but allows establishing HTTP connections.
Note: HTTP Tunnel and SSH Tunnel
cannot function simultaneously. The SSH Tunnel is disabled
when you select the HTTP Tunnel and vice versa.
Setting up HTTP Tunnel
To use this connection method, first thing you need to do
is to upload the tunneling script - ntunnel_pgsql.php
to the webserver.
Note: ntunnel_pgsql.php
is available in the installation package.
The following instruction guides you through the process
of configuring a HTTP connection.
- Click
 or choose Connection
> New Connection to set up the Connection Properties.
- Select the HTTP tab and enable Use HTTP Tunnel.
- Enter URL of the tunneling script.
- If the ntunnel_pgsql.php is hosted in a password protected
server, you can provide the required authentication details.
- Navicat PostgreSQL host name at the General Settings page
should be set relatively to the HTTP server in this case.
For example: host_of_pgsqldatabase shown below is the host
address, which provided by your hosting company, of your
remote PostgreSQL database.
Connection Name
A friendly name to best describe your connection.
Host name/IP address
A host where PostgreSQL Server is located in point of view
HTTP server.
Port
A port of PostgreSQL Server on Remote Host, by default it
is 5432.
User name
It is a PostgreSQL Server user name.
Password
It is a password of the PostgreSQL user.
|
