Documentation
Connections
Postgres

Postgres

Supported databases

This connector supports PostgreSQL 9.6 through 16, including:

  • Self-hosted PostgreSQL installations
  • Managed PostgreSQL services (AWS RDS, Azure Database for PostgreSQL, Google Cloud SQL)
  • PostgreSQL-compatible services that fully implement the PostgreSQL wire protocol

Databases that only partially implement PostgreSQL (for example Amazon Redshift) are not supported.

Required connection parameters

You must provide the following:

  • Host – database server hostname or IP address
  • Port – default: 5432
  • Database name
  • Username
  • Password

The application automatically constructs the JDBC connection URL.

Supported authentication methods

  • Password authentication
  • SCRAM-SHA-256
  • MD5 authentication

Not supported

  • PostgreSQL versions older than 9.6
  • Unix domain socket connections
  • Kerberos or GSSAPI authentication
  • IAM- or token-based authentication
  • Custom JDBC URLs

Notes

  • SSL/TLS is supported and often required for cloud-hosted PostgreSQL.
  • Firewall access to the configured host and port must be allowed.
MySQL