| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- .. _data_wpsjdbc:
- WPS JDBC
- ========
- The WPS JDBC extension is a WPS status storage for asynchronous requests. Main advantages are:
- * Asynchronous request status sharing among multiple GeoServer nodes
- * Ability to retain the status of completed requests even after the GeoServer(s) have been restarted.
- .. _wpsjdbc_install:
- Installing the WPS JDBC extension
- ---------------------------------
- #. From the :website:`website download <download>` page, locate your release, and download: :download_extension:`wps-jdbc`
-
- Verify that the version number in the filename corresponds to the version of GeoServer you are running (for example |release| above).
- #. Extract the contents of the archive into the :file:`WEB-INF/lib` directory in GeoServer.
- Make sure you do not create any sub-directories during the extraction process.
- #. Restart GeoServer.
- Configuring the WPS JDBC properties
- -----------------------------------
- #. Create a file named `jdbcstatusstore.props` into the `GEOSERVER_DATA_DIR` root
- #. Update the sample content below accordingly to your connection parameters
- .. code-block::
- user=postgres
- port=5432
- password=******
- passwd=******
- host=localhost
- database=gsstore
- driver=org.postgresql.Driver
- dbtype=postgis
- #. 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.
- #. Create a shared folder that all the nodes can reach somehow, e.g. by using `nfs`
- #. From the GeoServer Admin dashboard, go to the `WPS` menu and edit the Resource Storage Directory accordingly
- .. figure:: images/wps-resource-storage-directory.png
- :align: center
- *WPS JDBC shared Resource Storage Directory*
|
