Postgres and PostGis , can not create extension

Question

I have installed postgresql 9.4 and postgis 2.1.5, and also dependecies. But when I fire in my terminal:

sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" test_base

I get:

ERROR: could not load library "/usr/lib/postgresql/9.4/lib/postgis-2.1.so": liblwgeom-2.1.5.so: cannot open shared object file: No such file or directory

which tells me that I'm missing something, after some googling around I have not found any solution :(

Is someone have experience with this?

It means that the extensions (.so libraries) have not been installed, so you cannot enable them. (they should live in the same directory as the postgres libs) — joop
– joop, Commented Feb 20, 2015 at 12:40
@dzordz Did you find a solution to your problem? If so, please share it here. — JJD
– JJD, Commented Jul 25, 2015 at 12:15
When you say you "installed" them, how did you do so? Build from source? Have you added /usr/local/lib to your /etc/ld.so.conf paths? — Paul Ramsey
– Paul Ramsey, Commented Sep 23, 2015 at 19:33
Run "find / -name liblwgeom-2.1.5.so" and see where the library actually is. — Paul Ramsey
– Paul Ramsey, Commented Sep 23, 2015 at 19:33

Bart · Accepted Answer · 2015-12-18 14:56:04Z

1

I had the same problem on my Ubuntu 14.04 with postgresql 9.4

I reinstalled postgis and this solved the problem:

apt-get install postgis

answered Dec 18, 2015 at 14:56

Bart

50411 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres and PostGis , can not create extension

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related