1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
PostGIS Extension for PostgreSQL
================================
PostgreSQL 9.1 (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.1 or later
* PostGIS must be configured and built ``--with-raster``
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/*``
|
