[Geoserver-users] help Automatic update

Hi all,
, Can anyone tell me please if data is held in PostgreSQL , and loaded to
Geoserver as PostGIS, can an update to the database be made to automatically
reflect in the OpenLayers map. That is can a script be written to refresh
the OpenLayers map from database at specified time intervals?
Thanks for any help
Chris

Hi Chris,

Database updates are reflected if you redraw the map in openlayers.

So for this to work you can set a timeout in your browser to call the redraw method of the WMS layer on a certain interval.

Or you can use some ajax call to find out if a change has been made in the db (you have to register that yourself) and call the redraw method then.

These are the options I can think of but it would be great if somebody new a way to tell the client to refresh (push instead of pull meganism)

It might be worth a try to post this to the openlayers list also, because that’s the place to build your functionality I guess

Cheers Kris

From: chris Wild [mailto:chrismwild@anonymised.com]
Sent: Friday, March 20, 2009 3:14 AM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] help Automatic update

Hi all,

, Can anyone tell me please if data is held in PostgreSQL , and loaded to
Geoserver as PostGIS, can an update to the database be made to automatically
reflect in the OpenLayers map. That is can a script be written to refresh
the OpenLayers map from database at specified time intervals?
Thanks for any help
Chris