WPS JDBC¶

Installing the WPS JDBC extension¶

1. From the website download page, locate your release, and download: geoserver-2.20-SNAPSHOT-wps-jdbc-plugin.zip

   Verify that the version number in the filename corresponds to the version of GeoServer you are running (for example 2.20-SNAPSHOT above).

2. Extract the contents of the archive into the WEB-INF/lib directory in GeoServer. Make sure you do not create any sub-directories during the extraction process.

3. Restart GeoServer.

Configuring the WPS JDBC properties¶

1. Create a file named jdbcstatusstore.props into the GEOSERVER_DATA_DIR root

2. Update the sample content below accordingly to your connection parameters

   user=postgres
   port=5432
   password=******
   passwd=******
   host=localhost
   database=gsstore
   driver=org.postgresql.Driver
   dbtype=postgis
   

3. Restart GeoServer

Share the WPS Execution Directory among the cluster nodes¶

Typically the WPS JDBC plugin is useful when setting up a GeoServer cluster.

The plugin allows sharing of the execution status among the nodes of the cluster.

Nevertheless, this won’t be sufficient. You will need to share the Execution folder too, in order to allow the different instances to correctly retrieve the executions results.

1. Create a shared folder that all the nodes can reach somehow, e.g. by using nfs

2. From the GeoServer Admin dashboard, go to the WPS menu and edit the Resource Storage Directory accordingly

WPS JDBC shared Resource Storage Directory¶