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?