NAME
Paws::DMS::PostgreSQLSettings
USAGE
This class represents one of two things:
Arguments in a call to a service
Use the attributes of this class as arguments to methods. You shouldn't make instances of this class. Each attribute should be used as a named argument in the calls that expect this type of object.
As an example, if Att1 is expected to be a Paws::DMS::PostgreSQLSettings object:
$service_obj->Method(Att1 => { AfterConnectScript => $value, ..., Username => $value });
Results returned from an API call
Use accessors for each attribute. If Att1 is expected to be an Paws::DMS::PostgreSQLSettings object:
$result = $service_obj->Method(...);
$result->Att1->AfterConnectScript
DESCRIPTION
Provides information that defines a PostgreSQL endpoint.
ATTRIBUTES
AfterConnectScript => Str
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.
Example: afterConnectScript=SET session_replication_role='replica'
CaptureDdls => Bool
To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.
If this value is set to N
, you don't have to create tables or triggers on the source database.
DatabaseName => Str
Database name for the endpoint.
DdlArtifactsSchema => Str
The schema in which the operational DDL database artifacts are created.
Example: ddlArtifactsSchema=xyzddlschema;
ExecuteTimeout => Int
Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.
Example: executeTimeout=100;
FailTasksOnLobTruncation => 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
.
If task is set to Limited LOB mode and this option is set to true, the task fails instead of truncating the LOB data.
MaxFileSize => Int
Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.
Example: maxFileSize=512
Password => Str
Endpoint connection password.
Port => Int
Endpoint TCP port.
SecretsManagerAccessRoleArn => Str
The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret
. SecretsManagerSecret
has the value of the AWS Secrets Manager secret that allows access to the PostgreSQL endpoint.
You can specify one of two sets of values for these permissions. You can specify the values for this setting and SecretsManagerSecretId
. Or you can specify clear-text values for UserName
, Password
, ServerName
, and Port
. You can't specify both. For more information on creating this SecretsManagerSecret
and the SecretsManagerAccessRoleArn
and SecretsManagerSecretId
required to access it, see Using secrets to access AWS Database Migration Service resources (https://docs.aws.amazon.com/https:/docs.aws.amazon.com/dms/latest/userguide/CHAP_Security.html#security-iam-secretsmanager) in the AWS Database Migration Service User Guide.
SecretsManagerSecretId => Str
The full ARN, partial ARN, or friendly name of the SecretsManagerSecret
that contains the PostgreSQL endpoint connection details.
ServerName => Str
Fully qualified domain name of the endpoint.
SlotName => Str
Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.
When used with the AWS DMS API CdcStartPosition
request parameter, this attribute also enables using native CDC start points.
Username => Str
Endpoint connection user name.
SEE ALSO
This class forms part of Paws, describing an object used in Paws::DMS
BUGS and CONTRIBUTIONS
The source code is located here: https://github.com/pplu/aws-sdk-perl
Please report bugs to: https://github.com/pplu/aws-sdk-perl/issues