The knowledge base blog https://www.esdm.co.uk/knowledge http://www.rssboard.org/rss-specification mojoPortal Blog Module en-GB 120 no WMS/WFS down when a GeoServer store is disabled after Windows updates Last night some of our servers restarted after scheduled updates, and we awoke to warning emails that some of our GIS web services were down. The affected WMS/WFS services were from GeoServer, so we knew immediately what to look for as this has happened before… the “Store” representing the connection to the GIS data repository – in this case a PostGIS database - had switched itself off, or become disabled:

GeoServer store disabled after server restart

Ticking the box and saving the Store fixed the problem.

Our hypothesis is that if the GeoServer service is re-started when the database server is not yet available, GeoServer automatically disables the affected Stores. [I later found this discussion in which one of the GroServer developers confirms that "the startup code checks if the stores are available, and if not, it
disables them".

We will try to prevent this happening again by ensuring that the GIS server is restarted well after the database servers, but we’d welcome any other ideas.


Crispin Flower  ...]]> https://www.esdm.co.uk/wmswfs-down-when-a-geoserver-store-is-disabled-after-windows-updates crispin.flower@idoxgroup.com (Crispin Flower) https://www.esdm.co.uk/wmswfs-down-when-a-geoserver-store-is-disabled-after-windows-updates https://www.esdm.co.uk/wmswfs-down-when-a-geoserver-store-is-disabled-after-windows-updates Thu, 13 Nov 2014 09:31:00 GMT Don't forget the PG tip When opening a PostGIS datasource using the OGR C# wrapper in .Net, the connection string must have "PG:" prefix, as follows:

...

Imports OSGeo.OGR

...

Dim drv As OSGeo.OGR.Driver = OSGeo.OGR.Ogr.GetDriverByName("PostgreSQL")
Dim connStr as string = "PG:dbname='myDB' host='192.168.etc.etc' port='5433' user='foo' password='bar'"
Dim ds As OSGeo.OGR.DataSource  = drv.Open(connStr, 0)


Crispin Flower  ...]]> https://www.esdm.co.uk/dont-forget-the-pg crispin.flower@idoxgroup.com (Crispin Flower) https://www.esdm.co.uk/dont-forget-the-pg https://www.esdm.co.uk/dont-forget-the-pg Tue, 15 Nov 2011 09:07:00 GMT PostgreSQL simple backup and restore To backup in verbose text format (from Windows/DOS command line):

pg_dump -C -f backupfile.sql -h localhost -p 5433 -U postgres databasename

To restore backup in verbose text format (from Windows/DOS command line):

psql -f backupfile.sql -U postgres -h localhost -p 5433


Crispin Flower  ...]]> https://www.esdm.co.uk/postgresql-simple-backup-and-restore crispin.flower@idoxgroup.com (Crispin Flower) https://www.esdm.co.uk/postgresql-simple-backup-and-restore https://www.esdm.co.uk/postgresql-simple-backup-and-restore Fri, 18 Dec 2009 15:50:41 GMT