Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. Current issues (6-30-2016):
  2. * ssh access to vibi machine from internal
  3.  
  4. Flights:
  5. * Lake-to-Lake
  6. * Cliff habitat in Bedford
  7.  
  8. VIBI
  9. * Additional Views
  10. * Plot x Species
  11. * Herbaceous
  12. * Woody
  13. * Concerns:
  14. * To what extent can we modify? Do we need training?
  15. * Next phase stuff:
  16. * Upgrade database to 9.5 or later
  17. * Add upsert logic to Fulcrum import process
  18. * Add FDW (or move database) to get database into PostGIS-Master
  19.  
  20. Documentation:
  21. * Database named vibi
  22. * Running 9.4.8
  23.  
  24. Other Stuff
  25. * FDW of GIS Maintained layers
  26. * Database connection from Tilemill to PostGIS Master are problematic. Working on a ogr_fdw to make the tables local, but having problems with windows install of ogr_fdw:
  27.  
  28. ```SQL
  29. SELECT version();
  30.  
  31. DROP EXTENSION ogr_fdw;
  32. CREATE EXTENSION ogr_fdw;
  33.  
  34. CREATE SERVER test FOREIGN DATA WRAPPER ogr_fdw
  35. OPTIONS (datasource 'PG:dbname=NR_monitoring host=10.0.0.27 port=5432 user=jreinier password=carex91308',
  36. format 'PostgreSQL' );
  37.  
  38. CREATE SCHEMA IF NOT EXISTS ss;
  39. IMPORT FOREIGN SCHEMA "NR_monitoring."
  40. FROM SERVER svr_sqlserver INTO ss;
  41. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement