Package com.pulumi.aws.dms.outputs

Class EndpointPostgresSettings

  • public final class EndpointPostgresSettings
extends java.lang.Object

    • Method Detail

      • afterConnectScript

        public java.util.Optional<java.lang.String> afterConnectScript()
        Returns:
        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

        public java.util.Optional<java.lang.String> authenticationMethod()
        Returns:
        Specifies the authentication method. Valid values: `password`, `iam`.

      • babelfishDatabaseName

        public java.util.Optional<java.lang.String> babelfishDatabaseName()
        Returns:
        The Babelfish for Aurora PostgreSQL database name for the endpoint.

      • captureDdls

        public java.util.Optional<java.lang.Boolean> captureDdls()
        Returns:
        To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts.

      • databaseMode

        public java.util.Optional<java.lang.String> databaseMode()
        Returns:
        Specifies the default behavior of the replication's handling of PostgreSQL- compatible endpoints that require some additional configuration, such as Babelfish endpoints.

      • ddlArtifactsSchema

        public java.util.Optional<java.lang.String> ddlArtifactsSchema()
        Returns:
        Sets the schema in which the operational DDL database artifacts are created. Default is `public`.

      • executeTimeout

        public java.util.Optional<java.lang.Integer> executeTimeout()
        Returns:
        Sets the client statement timeout for the PostgreSQL instance, in seconds. Default value is `60`.

      • failTasksOnLobTruncation

        public java.util.Optional<java.lang.Boolean> failTasksOnLobTruncation()
        Returns:
        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

        public java.util.Optional<java.lang.Boolean> heartbeatEnable()
        Returns:
        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

        public java.util.Optional<java.lang.Integer> heartbeatFrequency()
        Returns:
        Sets the WAL heartbeat frequency (in minutes). Default value is `5`.

      • heartbeatSchema

        public java.util.Optional<java.lang.String> heartbeatSchema()
        Returns:
        Sets the schema in which the heartbeat artifacts are created. Default value is `public`.

      • mapBooleanAsBoolean

        public java.util.Optional<java.lang.Boolean> mapBooleanAsBoolean()
        Returns:
        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

        public java.util.Optional<java.lang.Boolean> mapJsonbAsClob()
        Returns:
        Optional When true, DMS migrates JSONB values as CLOB.

      • mapLongVarcharAs

        public java.util.Optional<java.lang.String> mapLongVarcharAs()
        Returns:
        Specifies how DMS maps LONG VARCHAR values. Valid values are `wstring`, `clob`, and `nclob`.

      • maxFileSize

        public java.util.Optional<java.lang.Integer> maxFileSize()
        Returns:
        Specifies the maximum size (in KB) of any `.csv` file used to transfer data to PostgreSQL. Default is `32,768 KB`.

      • pluginName

        public java.util.Optional<java.lang.String> pluginName()
        Returns:
        Specifies the plugin to use to create a replication slot. Valid values: `pglogical`, `test-decoding`.

      • serviceAccessRoleArn

        public java.util.Optional<java.lang.String> serviceAccessRoleArn()
        Returns:
        Specifies the IAM role to use to authenticate the connection.

      • slotName

        public java.util.Optional<java.lang.String> slotName()
        Returns:
        Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.