Amazon RDS for PostgreSQL as a Target

Overview

This page describes the setup process using Amazon RDS for 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 RDS PostgreSQL

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

1. Select Amazon RDS for 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 RDS for PostgreSQL is used as a target system, the mapping of Syniti Replicate data types to the corresponding data type in Amazon RDS for PostgreSQL is listed in the following table:

Limitations

Refresh: Bulk Insert uses only Native as Bulk Type.