PostgreSQL Reader properties
Striim provides templates for creating applications that read from PostgreSQL and write to various targets. See Creating an application using a template for details.
The PostgreSQL JDBC driver is included with the Striim server. When running a PostgreSQLReader source with the Forwarding Agent, the driver must be installed as described in Install the PostgreSQL JDBC driver.
property | type | default value | notes |
---|---|---|---|
Bidirectional Marker Table | String | When performing bidirectional replication, the fully qualified name of the marker table (see Bidirectional replication). This setting is case-sensitive. | |
CDDL Action | enum | Process | |
CDDL Capture | Boolean | False | |
CDDL Tracking Table | String | ||
Connection Retry Policy | String | retryInterval=30, maxRetries=3 | With the default setting, if a connection attempt is unsuccessful, the adapter will try again in 60 seconds ( |
Connection URL | String |
| |
Excluded Tables | String | Change data for any tables specified here will not be returned. For example, if | |
Filter Transaction Boundaries | Boolean | True | With the default value of True, begin and commit transactions are filtered out. Set to False to include begin and commit transactions. |
JAAS Configuration | String | If you Enable Kerberos authentication for Oracle and PostgreSQL, use this property to configure it. To authenticate PostgreSQL, specify For example, You must also append the appropriate application name from the specified ' | |
Password | encrypted password | the password specified for the username (see Encrypted passwords) | |
Postgres Config | sSring | {"ReplicationPluginConfig": {"Name": "WAL2JSON", "Format": "1"}} | Change |
Replication Slot Name | String | striim_slot | The name of the replication slot created as described in PostgreSQL setup. If you have multiple instances of PostgreSQLReader, each must have its own slot. |
Start LSN | String | By default, only new transactions are read. Optionally, specify a log sequence number to start reading from that point. | |
Tables | String | The table(s) for which to return change data. Tables must have primary keys (required for logical replication). Names are case-sensitive. Specify source table names as You may specify multiple tables as a list separated by semicolons or using the following wildcards in the schema and/or table names only (not in the database name):
For example, All tables specified must have primary keys. Tables without primary keys are not included in output. If any specified tables are missing PostgresReader will issue a warning. If none of the specified tables exists, start will fail with a "found no tables" error. If you have multiple instances of PostgreSQLReader, each should read a separate set of tables. | |
Username | String | the login name for the user created as described in PostgreSQL setup |