[pgrouting-users] pgrouting installation

Charles Galpin cgalpin at lhsw.com
Tue Sep 13 08:54:57 EDT 2011


I have used pgrouting on Windows 7 so I think this should work (everything else installed via stackbuilder)

What do you get for this query?

select * from ways where source = 24154 or target = 24157


charles

On Sep 13, 2011, at 8:37 AM, Daniel Kastl wrote:

> Hi Ali,
> 
> I may be wrong, and if there are Windows users out there who know it better, please correct me.
> But the binaries for pgRouting were not compiled with Windows 7. They might work, but not necessarily.
> 
> Daniel
> 
> 
> On Tue, Sep 13, 2011 at 2:39 AM, Ali Taha <ali.taha at ritaj.ps> wrote:
> 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: daniel.kastl at georepublic.de
> Web: http://georepublic.de
> 
> 
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
> 
> 
> 
> 
> -- 
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

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


More information about the Pgrouting-users mailing list