pulumi-aws-kotlin/com.pulumi.aws.dms.kotlin.outputs/EndpointPostgresSettings

EndpointPostgresSettings

data class EndpointPostgresSettings(val afterConnectScript: String? = null, val babelfishDatabaseName: String? = null, val captureDdls: Boolean? = null, val databaseMode: String? = null, val ddlArtifactsSchema: String? = null, val executeTimeout: Int? = null, val failTasksOnLobTruncation: Boolean? = null, val heartbeatEnable: Boolean? = null, val heartbeatFrequency: Int? = null, val heartbeatSchema: String? = null, val mapBooleanAsBoolean: Boolean? = null, val mapJsonbAsClob: Boolean? = null, val mapLongVarcharAs: String? = null, val maxFileSize: Int? = null, val pluginName: String? = null, val slotName: String? = null)

Constructors

fun EndpointPostgresSettings(afterConnectScript: String? = null, babelfishDatabaseName: String? = null, captureDdls: Boolean? = null, databaseMode: String? = null, ddlArtifactsSchema: String? = null, executeTimeout: Int? = null, failTasksOnLobTruncation: Boolean? = null, heartbeatEnable: Boolean? = null, heartbeatFrequency: Int? = null, heartbeatSchema: String? = null, mapBooleanAsBoolean: Boolean? = null, mapJsonbAsClob: Boolean? = null, mapLongVarcharAs: String? = null, maxFileSize: Int? = null, pluginName: String? = null, slotName: String? = null)

Types

Companion

object Companion

Properties

afterConnectScript

val afterConnectScript: String? = null

For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.

babelfishDatabaseName

val babelfishDatabaseName: String? = null

The Babelfish for Aurora PostgreSQL database name for the endpoint.

captureDdls

val captureDdls: Boolean? = null

To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts.

databaseMode

val databaseMode: String? = null

Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.

ddlArtifactsSchema

val ddlArtifactsSchema: String? = null

Sets the schema in which the operational DDL database artifacts are created. Default is public.

executeTimeout

val executeTimeout: Int? = null

Sets the client statement timeout for the PostgreSQL instance, in seconds. Default value is 60.

failTasksOnLobTruncation

val failTasksOnLobTruncation: Boolean? = null

When set to true, this value causes a task to fail if the actual size of a LOB column is greater than the specified LobMaxSize. Default is false.

heartbeatEnable

val heartbeatEnable: Boolean? = null

The write-ahead log (WAL) heartbeat feature mimics a dummy transaction. By doing this, it prevents idle logical replication slots from holding onto old WAL logs, which can result in storage full situations on the source.

heartbeatFrequency

val heartbeatFrequency: Int? = null

Sets the WAL heartbeat frequency (in minutes). Default value is 5.

heartbeatSchema

val heartbeatSchema: String? = null

Sets the schema in which the heartbeat artifacts are created. Default value is public.

mapBooleanAsBoolean

val mapBooleanAsBoolean: Boolean? = null

You can use PostgreSQL endpoint settings to map a boolean as a boolean from your PostgreSQL source to a Amazon Redshift target. Default value is false.

mapJsonbAsClob

val mapJsonbAsClob: Boolean? = null

Optional When true, DMS migrates JSONB values as CLOB.

mapLongVarcharAs

val mapLongVarcharAs: String? = null

Optional When true, DMS migrates LONG values as VARCHAR.

maxFileSize

val maxFileSize: Int? = null

Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL. Default is 32,768 KB.

pluginName

val pluginName: String? = null

Specifies the plugin to use to create a replication slot. Valid values: pglogical, test_decoding.

slotName

val slotName: String? = null

Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.