![]() ![]() 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. Require - establish only a secure SSL connection.Prefer - try first an SSL connection, then if that fails, try a none-SSL connection.If this mode is selected, SSL is not used, and other SSL parameters are not available. Disable - establish only an unencrypted SSL connection.Allow - try first a non-SSL connection, then if that fails, try an SSL connection.You can select any of the following modes: SSL Mode - this mode determines the priority of using secure SSL connection.If you want to use SSL or SSH connection, additionally you need to click Advanced Settings and select the required Protocol.Īfter this, for SSL connection you need to specify: If you need to pass UTF8 characters to a PostgreSQL database, click Advanced Settings and select the Unicode checkbox. Schema - name of the PostgreSQL schema you want to connect to.Database - name of the PostgreSQL database you want to connect to.Port - PostgreSQL Server connection port default value is 5432.Server - name or IP address of the PostgreSQL Server host to connect to.Name - connection name that will be used to identify the connection in the objects list and when selecting a connection for a package. ![]() You need to specify the following parameters for TCP/IP PostgreSQL connection: ![]() You can find some advice on configuring your PostgreSQL server in order to connect to it from Skyvia directly in the How to Configure Local Database Server to Access It from Skyvia topic.Īgent connections don’t have such requirements, but you need to install the Skyvia Agent application in order to use them. In order to use a direct connection, your PostgreSQL server must be available through the Internet. To connect to a PostgreSQL server, you need to specify the database server host name or IP address, the port the PostgreSQL server is running on, the user name and password to log in with, and the database name.įor connecting to local PostgreSQL servers, Skyvia offers two options: direct connections and agent connections. Skyvia supports synchronization of PostgreSQL servers of versions 8.3 and higher and Amazon Aurora PostgreSQL. Skyvia supports usual TCP/IP PostgreSQL connections and secure SSL and SSH connections. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |