PostgreSQLConnectionPool

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 NameAPI NameDefault ValueAllowable ValuesDescription
Database Versiondatabase-versionPostgreSQL 8.2 and newer
  • PostgreSQL 8.2 and newer PostgreSQL JDBC 4.2 Driver 42.6.0 or newer for PostgreSQL 8.2 and newer versions
  • PostgreSQL 8.1 and older Java JDBC 4.2 (JRE 8+) driver for PostgreSQL databases older than 8.2
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 Hostnamedatabase-hostnamelocalhostThe hostname of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database Portdatabase-port5432The port of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database Namedatabase-nameThe name of the database to connect. Defaults to the Database User.
Supports Expression Language: true (will be evaluated using variable registry only)
Database UserDatabase UserDatabase user name
Supports Expression Language: true (will be evaluated using variable registry only)
PasswordPasswordThe password for the database user
Sensitive Property: true
Supports Expression Language: true (will be evaluated using variable registry only)
SSL Modessl-modeDisabled
  • Disabled TLS encryption disabled.
  • Required TLS encryption enabled with certificate verification.
The SSL mode to use when connection to the database.
SSL Context ServiceSSL Context ServiceController 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.