Amazon Aurora PostgreSQL as a Target

Overview

This page describes the setup process using Amazon Aurora PostgreSQL as target system in a replication using Refresh or Mirroring mode.

User Permissions

The user performing operations should have the following PostgreSQL permissions:

• CONNECT: Required to connect to the database.

• USAGE on Schemas: Grants access to specific schemas where tables are located.

• SELECT on Tables: Required to read data from the tables where CDC will be performed.

• INSERT/UPDATE/DELETE: If changes to data or loading back are needed, these privileges are also required on the target tables.

-- Grant required permissions to the PostgreSQL user
CREATE USER your_user WITH PASSWORD 'your_password';
GRANT CONNECT ON DATABASE your_database TO your_user;
GRANT USAGE ON SCHEMA your_schema TO your_user;

-- OPTIONAL
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA your_schema TO you_user;

Create a Target Connection with Amazon Aurora PostgreSQL

Open the Management Center, under the source connections create a new connection

1. Select Amazon Aurora PostgreSQL as the database from the list.

2. Select PostgreSQL .NET Driver as a Provider.

3. For lower versions of Syniti Replicate 10.7.0.21 locate the .NET Assembly Npgsql.dll in the installation folder for the PostgreSQL .NET Provider. For Syniti Replicate 10.7.0.21 or higher the .NET assembly is included with the installation package.

4. Add the connection properties.

5. Complete the Wizard.

Optional: You can execute the Create Target Table Wizard to create the target table according the follow data type Mapping.

Data Type Mapping

When Amazon Aurora PostgreSQL is used as a target system, the mapping of Syniti Replicate data types to the corresponding data type in Amazon Aurora PostgreSQL is listed in the following table:

Limitations

Refresh: Bulk Insert uses only Native as Bulk Type.