pgRouting

Ticket #82 (closed feature request: fixed)

Opened 1 year ago

Last modified 1 year ago

Getting pgRouting running in Windows

Reported by: andresch Assigned to: anton
Priority: major Milestone:
Component: pgRouting package Version: 1.0.0a
Keywords: missing files or command Cc:

Description

I installed Postgresql, Postgis and the win32 exe for pgRouting. I also loaded all my route shp files into a database. I now need to add the pgrouting function to PostGis??, but getting an error on the psql command: "psql -U postgres -f <filename> <database>" I only have 1 file in "C:\Program Files\PostgreSQL\8.2\share\contrib\postgis\lwpostgis_upgrade", but not spatial_ref_sys.sql

I do not have routning_wrappers.sql in C:\Program Files\PostgreSQL\8.2\share\.

what should the commandline be like? are the *_wrapers.sql and spatial_ref_sys.sql files esential for Windows also?

Change History

10/03/07 09:40:44 changed by anton

  • owner changed from somebody to anton.
  • status changed from new to assigned.
  • component changed from A* to pgRouting package.

Hi Andre,

1. In 1.0.0a you need to use routing_postgis.sql instead of routing_wrappers.sql 2. I already wrote you about spatial_ref_sys.sql in my email, but I will repeat it here - there should be such file, and if you don't have it, it looks like something wrong with the PostGIS installation.

10/04/07 14:21:46 changed by anton

  • status changed from assigned to closed.
  • resolution set to fixed.