New answers tagged pgadmin-3
You seem to have a PostGIS installation that was created by loading the postgis.sql file, rather than using the CREATE EXTENSION postgis command. So when you dumped your database, you got not only the data, but also all the function definitions, which includes references to the 2.1 PostGIS library. Install PostGIS 2.1.8 on your new system. Create a blank ...
Based on: SELECT generate_series(161794, 161797, 3); generate_series ----------------- 161794 161797 (2 rows) you can use the many to many signature of pgr_dijkstra: http://docs.pgrouting.org/2.2/en/src/dijkstra/doc/pgr_dijkstra.html#dijkstra-many-to-many WITH my_source_series AS (SELECT generate_series(161794, 161797, 3) AS ...
You might consiider PostGIS FDW (Foreign Data Wrapper) - it will connect to remote files such as Shapefiles or CSV, and they will appear and be queryable just like 'normal' PostGres tables. I think you'd need to use the GDAL/OGR FDW library - it supports shapefile connections. But don't take my word for it: http://postgis.net/2014/12/19/postgis_fdw/
Top 50 recent answers are included