Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Current issues (6-30-2016):
- * ssh access to vibi machine from internal
- Flights:
- * Lake-to-Lake
- * Cliff habitat in Bedford
- VIBI
- * Additional Views
- * Plot x Species
- * Herbaceous
- * Woody
- * Concerns:
- * To what extent can we modify? Do we need training?
- * Next phase stuff:
- * Upgrade database to 9.5 or later
- * Add upsert logic to Fulcrum import process
- * Add FDW (or move database) to get database into PostGIS-Master
- Documentation:
- * Database named vibi
- * Running 9.4.8
- Other Stuff
- * FDW of GIS Maintained layers
- * 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:
- ```SQL
- SELECT version();
- DROP EXTENSION ogr_fdw;
- CREATE EXTENSION ogr_fdw;
- CREATE SERVER test FOREIGN DATA WRAPPER ogr_fdw
- OPTIONS (datasource 'PG:dbname=NR_monitoring host=10.0.0.27 port=5432 user=jreinier password=carex91308',
- format 'PostgreSQL' );
- CREATE SCHEMA IF NOT EXISTS ss;
- IMPORT FOREIGN SCHEMA "NR_monitoring."
- FROM SERVER svr_sqlserver INTO ss;
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement