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... read more Posted by Crispin Flower 13 November 2014 Categories: GeoServer PostgreSQL/PostGIS SQL Server Comments(0)
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... read more Posted by Crispin Flower 15 November 2011 Categories: OGR/GDAL PostgreSQL/PostGIS Comments(0)
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... read more Posted by Crispin Flower 18 December 2009 Categories: PostgreSQL/PostGIS Comments(0)