... 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 had become corrupted b/c client was using PG Admin instead of ArcGIS Desktop to do schema changing operations (deleting tables). Clearly these actions should be done with Desktop in the future (Catalog). To fix this I deleted the SDE and reconfigured with the SDE Post-Installer. This may also be fixable using
or some switch combo on sdegdbrepair
sdetable -o unregister
Error in event viewer:
FATAL: bogus data in lock file "postmaster.pid": ""
resolve by deleting the postmaster.pid file
Postgres Error Codes: http://www.postgresql.org/docs/9.3/static/errcodes-appendix.html
Deciphering Errors within ArcSDE