Skip to main content

Connect with Skyvia

Skyvia is an universal cloud data platform. This example shows how to configure PostgreSQL® as a connection in skyvia.

Variables

These are the placeholders you will need to replace your PostgreSQL® connection information:

VariableDescription
HOSTNAMEHostname for the PostgreSQL connection, from the service overview page
PORTPort for the PostgreSQL connection, from the service overview page
DATABASEDatabase Name for the PostgreSQL connection, from the service overview page
USERNAMEUsername for the PostgreSQL connection
PASSWORDPassword for the above specified username

Connect to PostgreSQL®

  1. In skyvia workspace > Connections > Connector > PostgreSQL.
  2. In the General Tab give the connection a name, for example MyDatabase.
  3. In the Connection tab, set:
    • Server to HOSTNAME
    • Port: to PORT
    • User ID to USERNAME
    • Password to PASSWORD
    • Database to DATABASE
  4. Click Advanced Settings to expand the settings and set:
    • SSL Mode set to Require
    • In SSL CA Cert copy and paste CA Certificate from the Aiven Console
    • SSL Cert and SSL Key empty.
    • SSL TLS Protocol to 1.2.
  5. Click Save Connection.