Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

PostgreSQL Database Converter online Help

Prev Return to chapter overview Next

Connecting to the target database

PostgreSQL Database Converter allows you to connect to PostgreSQL directly, or via Secure SHell (SSH) tunnel, or HTTP tunnel.

 

Direct connection

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.

 

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.

 

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. Default PostgreSQL port is 5432.

 

SSL Options

It is possible for both the client and server to provide SSL certificates to each other. It takes some extra configuration on each side, but this provides stronger verification of identity than the mere use of passwords.

 

 More about SSL options

 

User name

The username used to connect to PostgreSQL.

 

Password

The password for the user account on server.

 

 More about SSH tunnel connection

 

 More about connection via HTTP tunnel

 



Prev Return to chapter overview Next