--- title: "Amazon RDS for PostgreSQL as a Target" slug: "amazon-rds-postgresql-as-target" updated: 2024-10-31T07:13:40Z published: 2024-10-31T07:13:40Z canonical: "skthelp.syniti.com/amazon-rds-postgresql-as-target" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # 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. ```plaintext -- 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](/v1/docs/postgresql-aurora). 5. Complete the Wizard. Optional: You can execute the [Create Target Table Wizard](/v1/docs/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: | **Syniti Replicate Mapping** | **Amazon RDS for PostgreSQL** | | --- | --- | | Bit | boolean | | Smallint | smallint | | Integer | integer, oid, cid, xid | | Bigint | bigint | | Double | float8, double precision | | Float | real | | Real | real | | Numeric | numeric | | Decimal | decimal | | Char | char, character, ""char"", bit | | Varchar | varchar, character varying, bit varying | | LongVarchar | text | | Binary | bytea | | Varbinary | bytea | | LongVarbinary | bytea | | Date | date | | Time | time without time zone, time with time zone | | Timestamp | timestamp without time zone | | TimestampZ | timestamp with time zone | | Money | money | | Blob | bytea | | Clob | text | | Number | numeric | | AutoInteger | integer | | Tinyint | decimal(3) | | Smalldatetime | timestamp without time zone | | NChar | char | | NVarchar | varchar | | NText | text | | Smallmoney | money | | GUID | uuid | | AutoDecimal | numeric | | AutoNumeric | numeric | | AutoTinyint | tinyint | | AutoSmallint | smallint | | Sysname | varchar(128), name | | Xml | xml | | Json | json | ## Limitations **Refresh:** Bulk Insert uses only Native as Bulk Type.