postgis/extensions

PostGIS Extension for PostgreSQL
================================

PostgreSQL 9.6 (and up) supports PostGIS extensions. A database can easily be
extended to use PostGIS using the syntax::

  CREATE EXTENSION postgis;           -- Includes raster
  CREATE EXTENSION postgis_topology;  -- Depends on postgis

Requirements
------------
 * PostgreSQL 9.6 or later

Building and installing
-----------------------
First, make sure you follow the regular configuration and installation steps,
completing these steps::

  make
  make install

If you are building from the source SVN repository, it is also recommended to
make the comments, since the function descriptions will be included::

  make comments

Making the comments is not necessary if you are building from the tar.gz source
distributions, since these include pre-built ``postgis_comments.sql``,
``topology_comments.sql``, and ``raster_comments.sql`` files.

Then, to build and install the extensions::

  cd extensions
  make
  make install

The extensions are installed in `SHAREDIR/extension`. (If you're uncertain
where `SHAREDIR` is, run ``pg_config --sharedir``.)

Then in your PostgreSQL database run::

  CREATE EXTENSION postgis;
  CREATE EXTENSION postgis_topology;

The dependency logic should warn if you try to install ``postgis_topology``
without ``postgis`` or try to drop ``postgis`` without first dropping
``postgis_topology``.

You will also not be able to drop any PostGIS functions installed by the
extension.

Manual extension installation
-----------------------------
If you want to manually install the extensions from one server to another,
just copy over the following files to the `SHAREDIR/extension` directory:

 * PostGIS (including raster); from ``extensions/postgis``:
    ``postgis.control``
    ``sql/*``

 * Topology extension; from ``extensions/postgis_topolology``:
     ``postgis_topology.control``
     ``sql/*``