--- title: "PostgreSQL" slug: "postgresql" updated: 2025-07-15T08:19:38Z published: 2025-07-15T08:19:38Z canonical: "skthelp.syniti.com/postgresql" --- > ## 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. # PostgreSQL ## Overview This page provides the required information for setting up replications using PostgreSQL. Syniti Replicate supports use of PostgreSQL for: - [Refresh](/v1/docs/setting-up-a-replication) replications, both source and target - [Mirroring](/v1/docs/setting-up-a-replication) replications, both source and target. For source connections, Syniti Replicate offers the [Log Server Agent](/v1/docs/postgresql-as-source#enable-a-logbased-replication-from-postgresql) or [Triggers](/v1/docs/postgresql-as-source#enable-a-triggersbased-replication-from-postgresql) -based replication options. ### Versions Supported PostgreSQL is supported as source and target systems in Refresh, Mirroring, and Synchronization from PostgreSQL v11.x to PostgreSQL v16.x. ## Prerequisites - For versions prior to Syniti Replicate 10.7.0.21, ensure that you download the appropriate PostgreSQL .NET Data Provider from the [PostgreSQL](https://www.postgresql.org/docs/current/external-interfaces.html) website. For Syniti Replicate 10.7.0.21 or later versions, the NpgSQL driver is included with the installer. - Ensure that you have the Npgsql (file name: Npgsql.dll) assembly in your path name. For example, C:\Npgsql-3.2.6-net40\Npgsql.dll - The provider version number stored in the DBReplicator.exe.config file (in the Syniti Replicate hyper folder) must match the provider version that you are using. To change the version of the provider, specify the newVersion in the DBReplicator.exe.config file as follows: ```plaintext                 ``` ## Driver Matrix Driver Matrix only valid for previous versions of Syniti Replicate 10.7.0.21. | **Database Version** | **Driver Version** | | --- | --- | | Amazon Aurora PostgreSQL 11 | NpgSQL 4.0.2 | | Amazon Aurora PostgreSQL 12 | NpgSQL 4.0.11 | | Amazon Aurora PostgreSQL 13 | NpgSQL 4.0.11 | | Amazon Aurora PostgreSQL 14 | NpgSQL 8.0.3 | | Amazon Aurora PostgreSQL 15 | NpgSQL 8.0.3 | Install the driver DLL using the Microsoft Global Assembly Cache Tool (GAC). If the provider is not registered, you will receive the following error when attempting to use the provider: System.IO.FileNotFoundException: Could not load file or assembly 'Npgsql For more information about this error, refer to our [Knowledge Base](https://support.syniti.com/hc/en-us/articles/5726142875287-1670-Bulk-Insert-with-PostgreSQL-Target-Databases).