PostgreSQL

Overview

This page provides the required information for setting up replications using PostgreSQL.

Syniti Replicate supports use of PostgreSQL for:

• Refresh replications, both source and target

• Mirroring replications, both source and target. For source connections, Syniti Replicate offers the Log Server Agent or Triggers -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 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:

<dependentAssembly>
    <assemblyIdentity name="Npgsql" publicKeyToken="5d8b90d52f46fda7" culture="neutral">
    </assemblyIdentity>
    <bindingRedirect oldVersion="2.2.3.0" newVersion="2.2.3.0">
    </bindingRedirect>
</dependentAssembly>

Driver Matrix

Driver Matrix only valid for previous versions of Syniti Replicate 10.7.0.21.

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.