64 lines
1.9 KiB
Plaintext
64 lines
1.9 KiB
Plaintext
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/*``
|