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:
Variable | Description |
---|---|
HOSTNAME | Hostname for the PostgreSQL connection, from the service overview page |
PORT | Port for the PostgreSQL connection, from the service overview page |
DATABASE | Database Name for the PostgreSQL connection, from the service overview page |
USERNAME | Username for the PostgreSQL connection |
PASSWORD | Password for the above specified username |
Connect to PostgreSQL®
- In skyvia workspace > Connections > Connector > PostgreSQL.
- In the General Tab give the connection a name, for example
MyDatabase
. - In the Connection tab, set:
- Server to
HOSTNAME
- Port: to
PORT
- User ID to
USERNAME
- Password to
PASSWORD
- Database to
DATABASE
- Server to
- 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
.
- SSL Mode set to
- Click Save Connection.