Connect with Rivery
Configure PostgreSQL® as a connection in Rivery, a fully managed solution for data ingestion, transformation, orchestration, reverse ETL and more.
Variables
These are the placeholders you will need to replace from 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:
- Host to
HOSTNAME
- Port: to
PORT
- Database to
DATABASE
- User name to
USERNAME
- Password to
PASSWORD
- Host to
- Click SSL Options to expand the settings and set:
- SSL Mode set to
Require
- SSL Mode set to
- Click Save.