pgAgent Stumbling Blocks

In addition to doing scheduled backups from Postgres, we’ve also needed to load nightly dumps sent via scp to our database server’s filesystem.  I finally got pgAgent working, but it wasn’t without much consternation.  If you need to do this sort of thing on Windows, I’d recommend using Task Scheduler and a batch file if pgdump…

Importing Data Dump into Postgres

I needed to take four steps to import an Oracle binary dump into PostgreSQL Open Oracle dump with something like notepad++ or grap and do a find/replace for all the binary characters (these can be highlighted in notepad++) and replace them with something like a pipe character (“|”) If you know the special characters that…

SDE Errors

“ERROR: ESRI: error getting spatial references for srid = ” … uses public.sde_spatial_references instead of sde.sde_coordinate_systems, so cannot use standard srid … only have a selection of srid’s of loaded features … therefore use srid defined in public.sde_spatial_references “DBMS table not found xxx State ID = 9” … was getting this error after the SDE…

UD Map

Developed UD Map, a total rebuild of the previous ArcIMS/Tomcat-based online campus mapping system.  UD Map, a sophisticated integrated system leveraging: crowd-sourced and locally developed map layers; GUI data editing capabilities; operationalized publication of crowdsourced data; and API and web service functionality, providing exposure to other campus web applications.  UD Map utilized a fully open source stack including:…