Issue: CREATE EXTENSION do not work - Githubissues

microo8 / plgo

easily create postgresql extensions in golang; moved to gitlab.com/microo8/plgo

292 stars 23 forks source link

Issue: CREATE EXTENSION do not work #38

Closed biter777 closed 3 years ago

biter777 commented 3 years ago

Hi!

Thnx for support plgo! I use plgo more than a year, its work very good.

Today I try to reinstall extension on PG12 (via "CREATE EXTENSION xxx;"), but got a error:

ERROR:  incompatible library "/usr/lib/postgresql/12/lib/xxx.so": version mismatch
DETAIL:  Server is version 12, library is version 11.

Before that, I compiled the extension with PG12 headers (via change pl.go) #cgo CFLAGS: -I"/usr/include/postgresql/12/server" -fpic

But if I install the extension on the PG11 and upgrade PG to PG12, it's work fine. How I can install a extension to PG12 ? Help please

p.s. Sorry for PR, no issue posible for your repo

biter777 commented 3 years ago

I reinstall pg packages and it solved the problem.

apt-get reinstall postgresql-server-dev-12
apt-get reinstall golang-github-lib-pq-dev
apt-get reinstall postgresql-contrib
apt-get reinstall libpq-dev