[pgrouting-users] pgrouting installation

Ali Taha ali.taha at ritaj.ps
Tue Sep 13 04:39:55 EDT 2011


Dear Daniel,

 

I downloaded them from http://www.pgrouting.org/download.html  (windows
binaries section pgRouting-1.03_pg-8.4.2)

I have windows 7 OS

 

Thanks

 

 

From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Daniel Kastl
Sent: Tuesday, September 13, 2011 6:34 AM
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] pgrouting installation

 

 

On Mon, Sep 12, 2011 at 11:20 AM, Ali Taha <ali.taha at ritaj.ps> wrote:

Dear All,

 

I am trying to setup and test pgrouting, I followed the setups but it is
still not working.  If ollowed the following steps:

 

1-      Copay pgrouting libraries to ..\pgsql\8.4\lib

 

>From where did you copy them?

Did you compile? Which OS?

 

Daniel

 

 

 

 

2-      Execute routing_core.sql and routing_core_wrappers.sql

3-      Create a newtwork:

a.       Added source and target fields

b.      Execute Execute assign_vertex_id('<table>', float tolerance,
'<geometry column', '<gid>')

c.       Added indices 

d.      Added reverse_cost column.

Then I used the following query to retrieve records:

 

SELECT * FROM shortest_path('

SELECT gid as id,

source::integer,

target::integer,

length::double precision as cost

FROM ways',

24154,

24157,

false, false)

 

the query executes without errors, but return no data. I checked the table
and the records seems OK. 

is there a way to validate the database and verify the topology? How to make
sure that the pgrouting library (dlls) are installed and working correctly?

 

Thanks

 

 

 

 


_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users





 

-- 
Georepublic UG & Georepublic Japan
eMail:  <mailto:daniel.kastl at georepublic.de> daniel.kastl at georepublic.de
Web:  <http://georepublic.de/> http://georepublic.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110913/60c26f65/attachment.html


More information about the Pgrouting-users mailing list