Online Documentation for Data Export for PostgreSQL

Step 1 - Setting connection options


At this step you should specify necessary settings to establish connection to the source PostgreSQL database.

 

Step 1

 

Connection settings

Enter PostgreSQL host name in the Host field. The Host drop-down list contains the list of already registered hosts. For both types you should enter PostgreSQL port to connect through in the Port field.

 

Afterwards you should specify authentication settings: Login and Password.

The default superuser name is 'postgres' with the password specified during PostgreSQL server installation.

 

If necessary, use the drop-down list to specify the preferable Client charset to be used by the application.

 

If you are using the EMS SQL Management Studio for PostgreSQL version of Data Export for PostgreSQL then the Select registered database button is available. Click this button to pick a database already registered in the EMS SQL Management Studio in the Select Host or Database dialog.

 

RadioButton Connect through the Secure Shell (SSH) tunnel

Select this option to establish connection to an intermediate SSH server and forward all PostgreSQL commands through the secure tunnel.

 

To setup the connection via SSH tunnel, input the following values in the corresponding fields:

  • SSH host name is the name of the host where SSH server is running
  • SSH port indicates the port where SSH server is activated
  • SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of PostgreSQL server)
  • SSH password is the Linux/Windows user password

 

For details see SSH tunneling options.

 

RadioButton Connect through the HTTP tunnel

Select this option to access PostgreSQL server through the HTTP protocol in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to PostgreSQL, but allows HTTP connections.

 

In order to use HTTP tunneling for the connection, you need to upload the tunneling emsproxy.php script to the webserver and specify the URL in the corresponding box in the following format: http://webserver_address/emsproxy.php

 

Note that the emsproxy.php script file is included into the distribution package and can be found in Data Export installation directory.

 

For details see HTTP tunneling options.

 

 

If you get any difficulties connecting to the database, it can be useful to look through FAQs.

 

When you are done, press the Next button to proceed to the next step.