20.2. Installing Partitioned PostGIS

The partitioned PostGIS data store is bundled with the geomesa-gt command-line tools. See GeoTools Command-Line Tools for installation instructions.

20.2.1. Installing pg_cron in Postgres

The partitioning module requires the pg_cron PostgreSQL extension to be installed on the database being used. See pg_cron for details on installing the extension.

20.2.2. Installing Partitioned PostGIS in GeoServer

Warning

See GeoServer Versions to ensure that GeoServer is compatible with your GeoMesa version.

The partitioned PostGIS GeoServer plugin is bundled by default in a GeoMesa binary distribution. To install, extract $GEOMESA_GT_HOME/dist/gs-plugins/geomesa-gt-gs-plugin_${VERSION}-install.tar.gz into GeoServer’s WEB-INF/lib directory.

Restart GeoServer after the JARs are installed.

Note that the regular PostGIS data store can also be used instead, but some queries may be slower due to lack of optimization.

20.2.3. Upgrading Existing Schemas

Any existing feature types will not automatically benefit from upgrading the GeoMesa version, as the functions and procedures are stored in PostGIS itself. After upgrading GeoMesa versions, the procedures can be upgraded in one of two ways:

20.2.3.1. Command-line Tools Upgrade

The GeoMesa command line tools come with a command to upgrade the schema. See partition-upgrade for details.

20.2.3.2. Drop and Re-create the Main View

Alternatively, the main view for a feature type (which has the same name as the feature type) can be dropped using psql or another tool:

DROP VIEW my_feature_type;

Then the feature type can then be re-created using createSchema. Existing data will be preserved in the partitioned tables.