Skip to main content

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:

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:
    • Host to HOSTNAME
    • Port: to PORT
    • Database to DATABASE
    • User name to USERNAME
    • Password to PASSWORD
  4. Click SSL Options to expand the settings and set:
    • SSL Mode set to Require
  5. Click Save.