Postgis Syntax PARALLEL error

Question

I cannot create an extension in my db. gives an error message

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

Are there any solutions for this problem?

 PostgreSQL version 9.6. PostGis version 2.3. 

Thanks!

Answer 1

No one can debug this without knowing much more information, but it either

• error (syntax) of the extension itself
• you are not using PostgreSQL 9.6 (you may have an earlier version installed)

Connect to the database in which you launched CREATE EXTENSION and run this

 SELECT version(); 

My assumption is that you are not on server 9.6 and are connecting to an earlier version of PostgreSQL. PARALLEL has been new since 9.6 .