Description:
Provides PostgreSQL Connection Pooling Service with built-in JDBC driver. Connections can be requested from the pool and returned once they have been used.
Tags:
postgres, postgresql, dbcp, jdbc, database, connection, pooling, store
Properties:
In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.
| Display Name | API Name | Default Value | Allowable Values | Description |
|---|
| Database Version | database-version | PostgreSQL 8.2 and newer | - PostgreSQL 8.2 and newer
| List of database versions.
This property requires exactly one resource to be provided. That resource may be any of the following types: directory, URL.
|
| Database Hostname | database-hostname | localhost | | The hostname of the database to connect.
Supports Expression Language: true (will be evaluated using Environment variables only) |
| Database Port | database-port | 5432 | | The port of the database to connect.
Supports Expression Language: true (will be evaluated using Environment variables only) |
| Database Name | database-name | | | The name of the database to connect. Defaults to the Database User.
Supports Expression Language: true (will be evaluated using Environment variables only) |
| Database User | Database User | | | Database user name
Supports Expression Language: true (will be evaluated using Environment variables only) |
| Password | Password | | | The password for the database user
Sensitive Property: true
Supports Expression Language: true (will be evaluated using Environment variables only) |
| SSL Mode | ssl-mode | Disabled | - Disabled
- Required
| The SSL mode to use when connection to the database. |
| SSL Context Service | SSL Context Service | | Controller Service API:
SSLContextService
Implementations: StandardRestrictedSSLContextService
StandardSSLContextService | If specified, indicates the SSL Context Service that is used to communicate with the remote server. If not specified, communications will not be encrypted
This Property is only considered if the [SSL Mode] Property has a value of "Required". |
State management:
This component does not store state.Restricted:
This component is not restricted.System Resource Considerations:
None specified.