18.3. Partitioned PostGIS Data Store Parameters

The partitioned PostGIS data store uses the same parameters as the standard PostGIS data store, except that dbtype must be set to postgis-partitioned. See the JDBCDataStore and PostGIS Plugin for other parameters.

The following additional parameters are also supported:

Parameter

Type

Description

idle_in_transaction_session_timeout

Duration

Transaction idle timeout (e.g. 2 minutes). See the Postgres documentation for more information. Setting this timeout may help prevent abandoned queries from slowing down database operations.

read_access_roles

String

A comma-separated list of roles that should be granted read-only access to any new schemas. These roles must already exist in the database.

geomesa.metrics.registry

String

Specify the type of registry used to publish metrics. Must be one of none, prometheus, or cloudwatch. See Micrometer Metrics for registry details.

geomesa.metrics.registry.config

String

Override the default registry config. See Micrometer Metrics for configuration details.

18.3.1. Programmatic Access

An instance of a PostGIS data store can be obtained through the normal GeoTools discovery methods, assuming that the GeoMesa code is on the classpath.

Map<String, Object> parameters = new HashMap<>();
parameters.put("dbtype", "postgis-partitioned");
parameters.put("host", "localhost");
parameters.put("port", "5432");
parameters.put("database", "geomesa");
parameters.put("user", "postgres");
parameters.put("passwd", "postgres");
org.geotools.api.data.DataStore dataStore =
    org.geotools.api.data.DataStoreFinder.getDataStore(parameters);

More information on using GeoTools can be found in the GeoTools user guide.