"version mismatch" FATAL error when trying to start Postgres with cstore_fdw extension

[Alik]

Hi! I need to evaluate cstore_fdw for our application. Unfortunately I am experiencing problems building and running cstore on Mac.

First, I spent few fruitless days trying to build cstore_fdw version 1.2 on Mac OS 10.10 with Postgres 9.3 installed using a package manager. Once I installed Postgres 9.3 from sources I finally was able to build cstore_fdw.

My next problem is some sort library version mismatch. Once I enabled cstore_fdw extension in postgresql.conf, any attempt to start Postgres server leads to the following error:

$ /usr/local/pgsql/bin/pg_ctl start -D/usr/local/pgsql/data
server starting
$ FATAL:  incompatible library "/usr/local/pgsql/lib/cstore_fdw.so": version mismatch
DETAIL:  Server is version 9.3, library is version 9.4.

I will really appreciate any help!

Thank you,

--Alik

[Alik]

Update:

Attempted to install postgres using homebrew - the same result. I am going to try cstore_fdw with Postgres 9.4 now.

--Alik

[Alik]

Installed Postgres 9.4.2 from sources, built and configured cstore_fdw. Now I can enable cstore_fdw with no problems:

test=# CREATE EXTENSION cstore_fdw;

CREATE EXTENSION

test=#

[Hadi Moshayedi]

Hello Alik,
 

$ FATAL:  incompatible library "/usr/local/pgsql/lib/cstore_fdw.so": version mismatch
DETAIL:  Server is version 9.3, library is version 9.4.

This happens when you compile cstore (or any other extension) with one version of PostgreSQL, but try to use it with a different version of PostgreSQL.

To fix this, do a "make clean" and recompile the extension with a path to the correct postgres.

Thanks,

  -- Hadi

 

[Alik]

I should've figured it. Thank you for your help! 

--Alik