How to install PostGIS extension in GreenPlum docker container - Stack Overflow

admin管理员组

文章数量:1400469

I want to run a GreenPlum DB with PostGIS extension.

For that I ran it in a container:

docker run -p 5432:5432 --name greenplum_container --rm datagrip/greenplum:6.8

When I tried to create the extension with:

CREATE EXTENSION IF NOT EXISTS postgis;

I got the error:

SQL Error [58P01]: ERROR: could not open extension control file "/opt/greenplum-db-6.8.1/share/postgresql/extension/postgis.control": No such file or directory

and decided to install PostGIS in the container

docker exec -it greenplum_container bash

apt update
apt install postgis*
Geographic area: 8. Europe
Time zone: 34. Moscow

Executed:

CREATE EXTENSION IF NOT EXISTS postgis;

again and still got the error

Switched back to the container and found out that /opt/greenplum-db-6.8.1/share/postgresql/extension/postgis.control wasn't still available

Found it here

/usr/share/postgresql/10/extension/postgis.control

And copied it to the expected directory:

cp /usr/share/postgresql/10/extension/postgis* /opt/greenplum-db-6.8.1/share/postgresql/extension/

After that when I ran:

CREATE EXTENSION IF NOT EXISTS postgis;

I got another error:

SQL Error [42601]: ERROR: syntax error at or near "PARALLEL"
  Position: 2432

What could be wrong here? Is there a docker image with GreenPlum 6.8 and PostGIS anywhere?

本文标签： How to install PostGIS extension in GreenPlum docker containerStack Overflow