Changes between Version 3 and Version 4 of UsersWikiPostGIS24Debian9src


Ignore:
Timestamp:
Aug 19, 2017, 10:00:39 AM (5 years ago)
Author:
chrismarx
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostGIS24Debian9src

    v3 v4  
    33== Prerequisites ==
    44Several components are needed, which can either be built from source or installed from pre-built packages, as shown below. For a quick start, there are official Docker images for Postgres here [https://hub.docker.com/_/postgres/]
     5For some features to be enabled (like parallel query support for spatial joins), Postgres 10 is required, but most features work with 9.6
     6
     7With a Docker v10 image, postgres is already installed, but the server-dev package is required:
     8{{{
     9sudo apt-get install postgresql-server-dev-10
     10}}}
    511
    612Without the Docker image, start by first installing the Postgres package:
     
    915}}}
    1016
    11 Then for either approach, install the prerequisite packages using:
     17Then for either approach, install the prerequisite packages for PostGIS using:
    1218{{{
    1319sudo apt-get install build-essential libxml2-dev libgdal-dev libproj-dev libjson0-dev xsltproc docbook-xsl docbook-mathml
     
    1521
    1622=== Build GEOS 3.7.x ===
    17 PostGIS 2.4 is best used with GEOS >= 3.7 for several new features, however Debian wheezy only has GEOS 3.5.1 available in packages, so if you want the version that enables all features, GEOS needs to be built from source. If you don't need the new features(e.g ST_FrechetDistance), you can instead install the available version of GEOS {{{sudo apt-get libgeos-dev}}}.
     23PostGIS 2.4 is best used with GEOS >= 3.7 for several new features, however Debian stretch only has GEOS 3.5.1 available in system packages, so if you want to enable all features, GEOS needs to be built from source. If you don't need the new features(e.g ST_FrechetDistance), you can instead install the available version of GEOS {{{sudo apt-get libgeos-dev}}}.
    1824
    1925There are multiple ways to build GEOS from source, but this is the simplest (Note: currently version 3.7 is only available in the nightly build. When 3.7 is released, switch to that):
     
    4753== Spatially enabling a database ==
    4854
    49 Connect to your database using pgAdminIII or psql, and use the commands to add the PostgreSQL extensions. To add PostGIS with raster support:
     55Connect to your database using pgAdmin or psql, and use the commands to add the PostgreSQL extensions. To add PostGIS with raster support:
    5056{{{
    5157CREATE EXTENSION postgis;