Getting pgRouting running in Windows

[andresch]

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?

[anton]

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.