CODEWITHSUNDEEP
postgresqlpostgis
91DarioDev
91DarioDev

Reputation: 1690

postgres cannot create extension postgis

i installed postgres on a new vps and then i installed postgis, but trying to create a postgis extension i always get this error:

    create extension postgis;
ERROR:  could not load library "/usr/lib/postgresql/10/lib/rtpostgis-2.4.so": /usr/lib/x86_64-linux-gnu/libssl.so.1.1: version `OPENSSL_1_1_1' not found (required by /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20)

i have no idea how to solve it.

i also tried to install openssl and libssl-dev but didn't help

edit: i am using 18.04.4 LTS ubuntu

i install issuing: 

sudo apt install postgresql postgresql-contrib
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get update
sudo apt-get install postgis

Upvotes: 2

Views: 1699

Answers (1)

Jim Jones
Jim Jones

Reputation: 19623

Issue with Ubuntu 18.04

For missing OpenSSL 1.1.1 on Ubuntu 18.04 take a look at this answer. You might need to download the .deb file and install it manually.

PostgreSQL 10 and PostGIS 2.4

In this article a similar error is solved by creating a symbolic link to the rtpostgis library available in the system, so that you can trick PostGIS 2.4 into thinking that the file exists, e.g. rtpostgis-2.5.so to rtpostgis-2.4.so:

$ ln -s rtpostgis-2.4.so rtpostgis-2.5.so

PostgreSQL 10 and PostGIS 3

To install PostGIS 3 (newer version) in a PostgreSQL 10 environment try:

sudo apt-get install postgresql-10-postgis-3

After that you will have the required libraries to perform CREATE EXTENSION postgis.

Upvotes: 2

Related Questions