Exegesis Spatial Data Management

 

Posts in Category: PostgreSQL/PostGIS

WMS/WFS down when a GeoServer store is disabled after Windows updates

Posted by Crispin Flower 13 November 2014 Categories: GeoServer PostgreSQL/PostGIS SQL Server
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
 
Comments(0)

Don't forget the PG tip

Posted by Crispin Flower 15 November 2011 Categories: OGR/GDAL PostgreSQL/PostGIS
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
 
Comments(0)

PostgreSQL simple backup and restore

Posted by Crispin Flower 18 December 2009 Categories: PostgreSQL/PostGIS
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
 
Comments(0)
  • RSS
https://www.esdm.co.uk/Blog/ViewCategory.aspx?cat=5&mid=108&pageid=138