SQL Replication PostgreSQL

[Carlos Mendes]

Hi,

where should I put the Npgsql.dll in order to use SQL Replication with PostgreSQL?

Thanks in advance

[Chris Marisic]

What have you tried?

[Carlos Mendes]

The Plugins folder.

[Oren Eini (Ayende Rahien)]

See here:

http://fxjr.blogspot.co.il/2011/05/npgsql-design-time-support-preview.html

Basically, it needs to be in .config file for ravendb, probably need different version, etc, but that is the gist of it.

<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=2.0.11.91, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
  </DbProviderFactories>
</system.data>

Oren Eini

CEO

Mobile: + 972-52-548-6969

Office:  + 972-4-622-7811

Fax:      + 972-153-4622-7811

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Carlos Mendes]

Thank you Ayende.

[Oren Eini (Ayende Rahien)]

Did this work? 

If so, can you post the full details?

[Carlos Mendes]

Sure,

1) Download the latest stable PostgreSQL .Net Provider (http://npgsql.projects.pgfoundry.org/) and add Mono.Security.dll and Npgsql.dll to Raven's plugins folder 

2) Add the configuration you provided to Raven.Server.exe.config updating the Npgsql version

<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=2.1.3.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />

</DbProviderFactories>

</system.data>

3) Restart the server and... it works! 

I didn't have to add the DLLs to the GAC which is great.