search

tds-fdw / tds_fdw

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

I need remove TDS and install again #203

Open lanaparadinha opened 5 years ago

lanaparadinha commented 5 years ago

ERROR: incompatible library "/usr/lib/postgresql/9.6/lib/tds_fdw.so": version mismatch DETAIL: Server is version 9.6, library is version 10.0.

:(

lanaparadinha commented 5 years ago

root@DCCBDL01:/install/tds_fdw# make USE_PGXS=1 uninstall rm -f '/usr/lib/postgresql/9.6/lib/tds_fdw.so' rm -f '/usr/share/postgresql/9.6/extension'/tds_fdw.control rm -f '/usr/share/postgresql/9.6/extension'/tds_fdw--2.0.0-alpha.3.sql rm -f '/usr/share/doc/postgresql-doc-9.6/extension'/README.tds_fdw.md root@DCCBDL01:/install/tds_fdw# root@DCCBDL01:/install/tds_fdw# root@DCCBDL01:/install/tds_fdw# make USE_PGXS=1 install /bin/mkdir -p '/usr/lib/postgresql/9.6/lib' /bin/mkdir -p '/usr/share/postgresql/9.6/extension' /bin/mkdir -p '/usr/share/postgresql/9.6/extension' /bin/mkdir -p '/usr/share/doc/postgresql-doc-9.6/extension' /usr/bin/install -c -m 755 tds_fdw.so '/usr/lib/postgresql/9.6/lib/tds_fdw.so' /usr/bin/install -c -m 644 .//tds_fdw.control '/usr/share/postgresql/9.6/extension/' /usr/bin/install -c -m 644 .//sql/tds_fdw--2.0.0-alpha.3.sql '/usr/share/postgresql/9.6/extension/' /usr/bin/install -c -m 644 .//README.tds_fdw.md '/usr/share/doc/postgresql-doc-9.6/extension/' root@DCCBDL01:/install/tds_fdw#

and problem Persist...

DrLove73 commented 5 years ago

What version of tds_fdw have you installed? For PostgreSQL 9.6 you need to install "postgresql-96-tds_fdw" rather then "postgresql-10-tds_fdw"!

juliogonzalez commented 4 years ago

@lanaparadinha is this still a problem?

It seems to me that your default pg_config is for 10.0 while your default server is 9.6.