Postgis syntax PARALLEL error

Question

I can't create extension in my db. throws a error that says

CREATE EXTENSION postgis;
ERROR: syntax error at or near "PARALLEL"
  Position: 2445

Is there any solution for this issue ?

PostgreSQL version 9.6.
PostGis version 2.3.

Thanks !

Answer 1

No one could possibly debug this without knowing a lot more information, but it's either

• a (syntax) error in the extension itself
• you're not running PostgreSQL 9.6 (maybe you have some earlier version installed alongside it)

Connect to the database that you ran CREATE EXTENSION on, and run this

SELECT version();

My assumption is that you're not on a 9.6 server, and that you're connecting to some earlier version of PostgreSQL. PARALLEL was new with 9.6.