postgresql icon indicating copy to clipboard operation
postgresql copied to clipboard

Postgis not working.

Open jdeg opened this issue 3 years ago • 1 comments

I installed successfully Postgres (Centos 8 and Debian 9), but I was not able to install Postgis. Have someone tried to install it?

I tried with several Postgres versions, but none of them worked. In order to enable Postgis I only updated this variable

postgresql_ext_install_postgis: true

But not sure if there are any other configuration I have to make. After the installation I created a database and ran the query

CREATE EXTENSION postgis;

and got this message

SQL Error [58P01]: ERROR: could not open extension control file "/usr/pgsql-13/share/extension/postgis.control": No such file or directory

Even running this query

SELECT PostGIS_version();

Throws me an error. What other changes should I make to run Postgis?

jdeg avatar Jul 31 '21 17:07 jdeg

Check if postgis packages was installed by the role

apt list --installed | grep postgis

if no then check Ansible logs for task with name name: PostgreSQL | Extensions | Make sure the postgis extensions are installed | Debian

ZhukovAlexey avatar Oct 04 '21 12:10 ZhukovAlexey

Postgis is probably missing on your debian. Check the offcicial documentation

I close this issue cause it's two years old and it's not related to this project

MrMegaNova avatar Mar 29 '23 12:03 MrMegaNova