Menu
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?
432
PostGIS is an extension to PostgreSQL for storing and managing spatial information. To learn more about PostGIS, see PostGIS.net . Starting with version 10.5, PostgreSQL supports the libprotobuf 1.3. 0 library used by PostGIS for working with map box vector tile data.
However, Postgres. app has been adding support for other extensions, and now comes with support for PostGIS, PLV8 and MVT already built in. If you want PgRouting, you can use Homebrew to install the dependencies it needs, and build it from source.
SFCGAL, a C++ wrapper library around CGAL that supports ISO 19107:2013 and OGC Simple Features Access 1.2 for 3D operations, is now an optional included in PostGIS. This was a quiet outcome of the Boston Code Sprint after Paul Ramsey declared exact rational number representation would not make its way into PostGIS.
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
150
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.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
