The configuration parameters for the PostgreSQL connector are:
| Parameter | Required | Description |
|---|---|---|
| DB_USERNAME | Required | The database user to execute the statement as, for example: connector-user |
| DB_PASSWORD | Required | The password for the database user executing the statement |
| POSTGRES_HOST | Optional | The host address of the database, for example: postgres.example.com |
| POSTGRES_PORT | Optional | The port of the hosted database, for example: 421 |
| DB_NAME | Optional | The name of the database to execute the statement against, for example: inventory |
| DB_DATASOURCE | Required | The database datasource, the default value is a concatenation of POSTGRES_HOST, POSTGRES_PORT and DB_NAME: jdbc:postgresql://${POSTGRES_HOST}:${POSTGRES_PORT}/${DB_NAME} |
| DB_DRIVER_CLASS_NAME | Optional | The database driver to use. The default value is org.postgresql.Driver |