If someone makes changes to tables in PostGIS (that have already been published in Geoserver), will Geoserver notice the changes automatically in its stores or do the layers need to be re-published?

Would there be a way to schedule a bulk layer update every 24 hours?

  • Do you meand with changes just inserts/updates/deletes to table rows or also changes to the schema like alter table foo add column...? – user30184 May 3 '17 at 5:59

It depends.

Firstly, if you have a PostGIS layer, then GeoServer doesn't cache the data, it loads it all live from the database. So, you can update the database and GeoServer sees the most recent version.

But, if you use GeoWebCache to cache the tiles that GeoServer has rendered, then you will need to do something to get rid of old tiles. Two ways around this:

  1. For layers that don't need caching, you can turn off the automatic GWC integtation.
  2. For layers that you do want to cache, you can tell GWC to get rid of the cache, and optionally, generate a new cache using the REST API.

(As an aside, I have some timeseries raster layers, which need GeoServer's metadata to be updated when they change, and you can trigger GeoServer to re-inspect those using GeoServers REST API too.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.