ERROR: could not open extension control file "/usr/pgsql-9.6/share/extension/postgis.control": No such file or directory

Question

I want to deploy my project to VPS Centos7. But i am getting error while installing postgres. When i type

create extension postgis;

Getting error

ERROR: could not open extension control file "/usr/pgsql-9.6/share/extension/postgis.control": No such file or directory

Because postgis.contol is located in another place,

find /usr -name postgis.control

/usr/share/pgsql/extension/postgis.control

But postgres trying to create it from /usr/pgsql-9.6/share/extension/postgis.control

This question already was asked before, but my problem is other.

Just install PostGIS in the proper directory - where is the problem? — Laurenz Albe, Nov 18 '18 at 12:09

score 1 · Answer 1 · answered Nov 06 '19 at 09:11

1

For me, I run below command in Ubuntu, and the issue was resolved.

sudo apt install postgresql-10-postgis-scripts

then run

 CREATE EXTENSION postgis

It works fine for me.I hope it helps.

answered Nov 06 '19 at 09:11

Nija I Pillai

Do you know how you would go about doing this with yum? – Richard McCormick Nov 08 '22 at 22:46
were you able to figure it out for yum/dnf ? @RichardMcCormick – darth baba Mar 19 '23 at 18:13
@darthbaba I just ended up using a Docker image. Think you would have to pull the binaries to do a direct install – Richard McCormick Mar 20 '23 at 22:29

1 Answers1