Connecting to PostgreSQL

Skyvia supports usual TCP/IP PostgreSQL connections and secure SSL connections. Skyvia supports synchronization of PostgreSQL servers of versions 8.3 and higher and Amazon Aurora PostgreSQL.

To connect to a PostgreSQL server, you need to specify the database server host name or IP address, the port the PostgreSQL server is listening,  the user name and password to login, and the database name.

note Important Note

Your PostgreSQL server must be available through the Internet in order for Skyvia to connect to it.

You can find some advices on configuring your PostgreSQL server in order to access it from Skyvia in the How to Configure Local Database Server to Access It from Skyvia topic.

Skyvia will access your server from the IP 40.118.246.204.

postgresql-connection-new

You need to specify the following parameters for TCP/IP PostgreSQL connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Server - the name or IP address of the PostgreSQL Server host to which to connect. Leaving this field empty means using localhost.
Port - PostgreSQL Server connection port; default value is 5432.
User Id - the user name to login with.
Password - the password to login with.
Database - the name of the PostgreSQL database you want to connect to.
Schema - the name of the PostgreSQL schema you want to connect to.

note Important Note

If you need to pass UTF8 characters to a PostgreSQL database, click the Advanced button and select the Unicode check box.

If you want to use SSL connection, additionally you need to click the Advanced button and set the following parameters:

SSL Mode - this mode determines the priority of using secure SSL connection. You can select any of the following modes:
oAllow - try first a non-SSL connection, then if that fails, try an SSL connection.
oDisable - establish only an unencrypted SSL connection. If this mode is selected, SSL is not used, and other SSL parameters are not available. This mode is selected by default.
oPrefer - try first an SSL connection, then if that fails, try a none-SSL connection.
oRequire - establish only a secure SSL connection.
SSL CA Cert - the authority certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Cert - the client certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Key - the client private key. Paste the content of the key file into the box or click the button to open a multiline editor and paste the content of the key file there.

In the Advanced parameters you can also select the Unicode check box to use Unicode encoding for the connection.

Additionally the Advanced parameters include the Connection Timeout and Command Timeout parameters:

The Connection Timeout parameter determines the time (in seconds) to wait while trying to establish a connection before terminating the attempt and reporting an error.
The Command Timeout parameter specifies the wait time in seconds before terminating the attempt to execute a command and produce an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.

Generally you don't need to modify these parameters, but in some specific cases when a connection to the database server is not good or a command may take significant time to execute you may try increasing their values.