search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
379 stars 102 forks source link

Installing tds_fdw on postgresql 9.6-- library mismatch of server and library #156

Open devendra857 opened 6 years ago

devendra857 commented 6 years ago

When i am creating extension the following error occurred.

postgres=# create extension tds_fdw; ERROR: incompatible library "/opt/rh/rh-postgresql96/root/usr/lib64/pgsql/tds_fdw.so": version mismatch DETAIL: Server is version 9.6, library is version 9.5.

First Case -- I installed freetds-0.95.81..XXXX rpm . I assumed that it may be because of the library of freetds which was affecting it. then

Later on i built the rpms of latest freetds-1.00.81.XX.rpm but again it is showing the same error.

Please help if anyone has came up with this issue/ or has installed tds_fdw on postgresql 9.6

juliogonzalez commented 6 years ago

Please tell us how you built tds_fdw (commands, logs...)

The error is clear, you have PostgreSQL 9.6 but somehow you have tds_fdw built for PostgreSQL 9.5.

devendra857 commented 6 years ago

I built the tds_fdw by compiling it (i.e make and install)

I am using 1.0.8. Is there anything I can do /you can suggest that needs to be done to overcome this issue

lalligood commented 6 years ago

It appears that you may have followed the instructions for compiling tds_fdw a little too literally. While the instructions specifically reference 9.5 in the example commands, you need to go through the steps again replacing all of the "95"s & "9.5"s with "96"s & "9.6"s if you want to use it with 9.6.

HTH,

--Lance

On Mon, Feb 5, 2018 at 10:11 AM, devendra857 notifications@github.com wrote:

I am using 1.0.8. Is there anything I can do /you can suggest that needs to be done to overcome this issue

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/tds-fdw/tds_fdw/issues/156#issuecomment-363039120, or mute the thread https://github.com/notifications/unsubscribe-auth/ADbVH29MFNhcS6rnWP2fVbT_Sz9cCSeSks5tRtPmgaJpZM4R4E0D .