EndpointPostgresSettings class
Constructors
-
EndpointPostgresSettings({Input<String?>? afterConnectScript, Input<String?>? authenticationMethod, Input<String?>? babelfishDatabaseName, Input<bool?>? captureDdls, Input<String?>? databaseMode, Input<String?>? ddlArtifactsSchema, Input<int?>? executeTimeout, Input<bool?>? failTasksOnLobTruncation, Input<bool?>? heartbeatEnable, Input<int?>? heartbeatFrequency, Input<String?>? heartbeatSchema, Input<bool?>? mapBooleanAsBoolean, Input<bool?>? mapJsonbAsClob, Input<String?>? mapLongVarcharAs, Input<int?>? maxFileSize, Input<String?>? pluginName, Input<String?>? serviceAccessRoleArn, Input<String?>? slotName})
-
Creates a new EndpointPostgresSettings.
afterConnectScript 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.
authenticationMethod Specifies the authentication method. Valid values: password, iam.
babelfishDatabaseName The Babelfish for Aurora PostgreSQL database name for the endpoint.
captureDdls To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts.
databaseMode Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
ddlArtifactsSchema Sets the schema in which the operational DDL database artifacts are created. Default is public.
executeTimeout Sets the client statement timeout for the PostgreSQL instance, in seconds. Default value is 60.
failTasksOnLobTruncation 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 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 Sets the WAL heartbeat frequency (in minutes). Default value is 5.
heartbeatSchema Sets the schema in which the heartbeat artifacts are created. Default value is public.
mapBooleanAsBoolean 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 Optional When true, DMS migrates JSONB values as CLOB.
mapLongVarcharAs Specifies how DMS maps LONG VARCHAR values. Valid values are wstring, clob, and nclob.
maxFileSize Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL. Default is 32,768 KB.
pluginName Specifies the plugin to use to create a replication slot. Valid values: pglogical, test-decoding.
serviceAccessRoleArn Specifies the IAM role to use to authenticate the connection.
slotName Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.
const
-
EndpointPostgresSettings.fromMap(Map<String, dynamic> map)
-
factory
Properties
-
afterConnectScript
→ Input<String?>?
-
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.
final
-
authenticationMethod
→ Input<String?>?
-
Specifies the authentication method. Valid values:
password, iam.
final
-
babelfishDatabaseName
→ Input<String?>?
-
The Babelfish for Aurora PostgreSQL database name for the endpoint.
final
-
captureDdls
→ Input<bool?>?
-
To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts.
final
-
databaseMode
→ Input<String?>?
-
Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.
final
-
ddlArtifactsSchema
→ Input<String?>?
-
Sets the schema in which the operational DDL database artifacts are created. Default is
public.
final
-
executeTimeout
→ Input<int?>?
-
Sets the client statement timeout for the PostgreSQL instance, in seconds. Default value is
60.
final
-
failTasksOnLobTruncation
→ Input<bool?>?
-
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.
final
-
hashCode
→ int
-
The hash code for this object.
no setterinherited
-
heartbeatEnable
→ Input<bool?>?
-
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.
final
-
heartbeatFrequency
→ Input<int?>?
-
Sets the WAL heartbeat frequency (in minutes). Default value is
5.
final
-
heartbeatSchema
→ Input<String?>?
-
Sets the schema in which the heartbeat artifacts are created. Default value is
public.
final
-
mapBooleanAsBoolean
→ Input<bool?>?
-
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.
final
-
mapJsonbAsClob
→ Input<bool?>?
-
Optional When true, DMS migrates JSONB values as CLOB.
final
-
mapLongVarcharAs
→ Input<String?>?
-
Specifies how DMS maps LONG VARCHAR values. Valid values are
wstring, clob, and nclob.
final
-
maxFileSize
→ Input<int?>?
-
Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL. Default is
32,768 KB.
final
-
pluginName
→ Input<String?>?
-
Specifies the plugin to use to create a replication slot. Valid values:
pglogical, test-decoding.
final
-
runtimeType
→ Type
-
A representation of the runtime type of the object.
no setterinherited
-
serviceAccessRoleArn
→ Input<String?>?
-
Specifies the IAM role to use to authenticate the connection.
final
-
slotName
→ Input<String?>?
-
Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.
final
