Using PostGIS

To install PostGIS on a database, you can use the command line or the PostGIS/PgRouting Extension installer.

To install via command line:

1. Connect to PostgreSQL

root@geohelm:~# su - postgres
postgres@geohelm:~$ psql
psql (9.6.3)
Type "help" for help.



2. If you have not created a database, create one now.

postgres=# create database geohelm;


3. Connect to your database.

postgres=# \c geohelm
You are now connected to database "geohelm" as user "postgres".


4. Install the PostGIS extension.

geohelm=# create extension postgis;


Note: GeoHelm also includes fuzzy_match_string, tiger, postgis_topology.


3. Verify the installation via command line or the PostgreSQL Management Page:

geohelm=# \d
               List of relations
 Schema |       Name        | Type  |  Owner
 public | geography_columns | view  | postgres
 public | geometry_columns  | view  | postgres
 public | raster_columns    | view  | postgres
 public | raster_overviews  | view  | postgres
 public | spatial_ref_sys   | table | postgres
(5 rows)


To install using the PostGIS/PgRouting Extension installer, click on the Extensions button.

Select the target database from the drop-down as shown below:


You must FIRST install PostGIS prior to installing any other of the listed extensions.

Tick the PostGIS select button and then click the Save button as show below:



Once PostGIS has been installed on a target database, you can then return to install additional extensions:


You can also un-install Extensions using above.


Next: read the manual or jump to component pages below.

GeoHelm Home Page

Tomcat Config Page

Tomcat WARs Page

Java Page

GeoServer Page

PostgreSQL Page

Important Be sure to also view the sections below:

Securing Your Installation

Moving the GeoServer Data Directory

Command Line Usage