create postgis extension syntax error at or near "PARALLEL"

Question

When I try to enable the postgis extension in postgresql on windows I get the following error:

syntax error at or near "PARALLEL"

I have been looking, but cannot find anyone with this error. Any help?

Answer 1

While I had PostgreSQL 9.5 installed, I was using PostGIS intended for version 9.6. This caused the error.

Credits to a_horse_with_no_name

Answer 2

I just had the same error and solved it with the good old restart procedure:

# install or upgrade postgres and postgis
brew upgrade postgres
brew upgrade postgis

# drop extension in case of an update
DROP EXTENSION postgis

# restart postgres
pg_ctl -D /usr/local/var/postgres stop -s -m fast
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

# create extension
CREATE EXTENSION postgis

I think restarting postgres was the important step to resolve the issue.