Bundle: SQL Replication: PostgreSQL
To setup a replication to PostgreSQL following steps need to be done:
- Download Npgsql from here.
- Copy
Npgsql.dll
to Plugins directory. - Add following configuration to your server configuration file (
Raven.Server.exe.config
orWeb.config
)
<system.data>
<DbProviderFactories>
<add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=3.0.3.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
</DbProviderFactories>
</system.data>
Note
Remember that the version in provided factory must match the DLL version that you downloaded. Please change the 3.0.3.0
to the appropriate version if needed.
- Restart the server and setup replication according to your needs. Basic setup can be found here.