Online Documentation for DB Comparer for PostgreSQL
Setting database options
Database connection properties for the source and target databases are set in the same way.
If both the source and target databases are located on the same server, you can check the Both databases on the same server option and set all the properties (except for the database/schema name) only once.
Set the host name for PostgreSQL in the Host field. Type server name or IP address or set Localhost for local server. The Host drop-down list contains the list of already registered hosts. Specify the port value in the Port field.
Afterwards you should specify authorization settings: Login and Password.
The default superuser name is 'postgres' with the password specified during PostgreSQL server installation.
After that it is necessary to specify the database you are going to work with: type in its name in the Database field or use the ellipsis button to select one from the Select database list.
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 DB Comparer 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.
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
Note: When the SSH tunneling is set the '*' symbol appears on the tab header.
Use Private Key for authentication
Check this option to enable Private Keys usage for the connection.
For details see SSH tunneling options.
To use HTTP tunneling, just upload the tunneling script to the webserver where PostgreSQL server is located, or to any other webserver from which direct connections to your PostgreSQL server are allowed. This script exposes the PostgreSQL API as a set of web-services which are used by DB Comparer for PostgreSQL.
For details see HTTP tunneling options.
Select the required SSL mode from the dropdown menu: Disabled, Allow, Prefer, Require, Verify CA, Verify Full.
Select the path to the client root.crt file.
Select the path to the client certificate.
Select the path to the client private key.
Select the file for Certificate Revocation List.
When done, press the Next button to set compare options.