[pgrouting-users] PGRouting and Postgresql 9.2

Pieter_du_Plooy · March 3, 2013, 7:49am

Hi guys

Those who posted in February about PGRouting and Postgresql 9.2, I have built pgrouting from github against postgresql 9.2 for Windows 32 bit.

Anyone interested please contact me.

Pieter

Stephen_Woodbridge1 · March 3, 2013, 3:51pm

On 3/3/2013 2:49 AM, Pieter du Plooy wrote:

Hi guys

Those who posted in February about PGRouting and Postgresql 9.2, I have
built pgrouting from github against postgresql 9.2 for Windows 32 bit.

Anyone interested please contact me.

Pieter

Hi Pieter,

Can you send me details on how you did this?

I have build PostGIS 2.0 for Windows 64 and I will be doing the same for Windows 32 and also will be pgRouting for both of these. I also hope to get pgRouting to install as an extension under postgresql.

My end result is that I want to check in the build and document this process and scripts and check it into git so we have a repeatable process that anyone can replicate for building pgRouting.

Thanks,
-Steve

Pieter_du_Plooy · March 5, 2013, 5:15am

Stephen

I essentially took the pgrouting4w-master from https://github.com/sanak/pgrouting4w, and followed the guide from the Build.mingw file. I had problems building boost, but followed http://stackoverflow.com/questions/5299468/unable-to-build-boost-libraries-with-gcc to build bjam and then boost.

I am attaching an winrar file with the dll’s as well as the sql files which I modified according to Linux procedures as Postgres 9.2 uses LANGUAGE ‘c’ instead of LANGUAGE ‘C’ .

I would also like the ability to have pgrouting to be installed as Postgres 9.2 extensions in stead of doing a psql -f on all the sql files, but I didnt know how to do that, otherwise I also would have done that.

I personally feel the hassles building a 64 bit version outweighs the pro’s but that’s just me.

Pieter

pgrouting_postgis92.rar (748 KB)

···

On Sun, Mar 3, 2013 at 5:51 PM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

On 3/3/2013 2:49 AM, Pieter du Plooy wrote:

Hi guys

Those who posted in February about PGRouting and Postgresql 9.2, I have
built pgrouting from github against postgresql 9.2 for Windows 32 bit.

Anyone interested please contact me.

Pieter

Hi Pieter,

Can you send me details on how you did this?

I have build PostGIS 2.0 for Windows 64 and I will be doing the same for Windows 32 and also will be pgRouting for both of these. I also hope to get pgRouting to install as an extension under postgresql.

My end result is that I want to check in the build and document this process and scripts and check it into git so we have a repeatable process that anyone can replicate for building pgRouting.

Thanks,
-Steve

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

Stephen_Woodbridge1 · March 5, 2013, 5:51am

On 3/5/2013 12:15 AM, Pieter du Plooy wrote:

Stephen

I essentially took the pgrouting4w-master from
https://github.com/sanak/pgrouting4w, and followed the guide from the
Build.mingw file. I had problems building boost, but followed
http://stackoverflow.com/questions/5299468/unable-to-build-boost-libraries-with-gcc
to build bjam and then boost.

I am attaching an winrar file with the dll's as well as the sql files
which I modified according to Linux procedures as Postgres 9.2 uses
LANGUAGE 'c' instead of LANGUAGE 'C' .

Pieter,

Thank you for this it will save me a bunch of time once I tackle this.

I would also like the ability to have pgrouting to be installed as
Postgres 9.2 extensions in stead of doing a psql -f on all the sql
files, but I didnt know how to do that, otherwise I also would have done
that.

I have built an extension for some other code, and it is high on my list to get extensions working for pgRouting.

I personally feel the hassles building a 64 bit version outweighs the
pro's but that's just me.

I have gone through the process of building postgis on windows 64 bit and it is a bit tedious. I'm hoping that we can get this automated in the future, but we have a lot of other stuff to work on first.

Best regards,
-Steve

Pieter

On Sun, Mar 3, 2013 at 5:51 PM, Stephen Woodbridge
<woodbri@swoodbridge.com <mailto:woodbri@swoodbridge.com>> wrote:

    On 3/3/2013 2:49 AM, Pieter du Plooy wrote:

        Hi guys

        Those who posted in February about PGRouting and Postgresql 9.2,
        I have
        built pgrouting from github against postgresql 9.2 for Windows
        32 bit.

        Anyone interested please contact me.

        Pieter

    Hi Pieter,

    Can you send me details on how you did this?

    I have build PostGIS 2.0 for Windows 64 and I will be doing the same
    for Windows 32 and also will be pgRouting for both of these. I also
    hope to get pgRouting to install as an extension under postgresql.

    My end result is that I want to check in the build and document this
    process and scripts and check it into git so we have a repeatable
    process that anyone can replicate for building pgRouting.

    Thanks,
       -Steve

    _________________________________________________
    Pgrouting-users mailing list
    Pgrouting-users@lists.osgeo.__org
    <mailto:Pgrouting-users@lists.osgeo.org>
    http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users
    <http://lists.osgeo.org/mailman/listinfo/pgrouting-users>

Pieter_du_Plooy · March 5, 2013, 8:39am

Steve

On a side note, I got extremely frustrated that the binaries Sanak had was only for older Postgres versions so thats why I decided to do my own one.

If I had the knowledge, I would have done it in VC, but wasn’t really in the mood to go through that instructions as well. LOL.

I have read on the Postgis Forums that they were planning to include it with Postgis, but haven’t seen anything further on it.

Pieter

···

On Tue, Mar 5, 2013 at 7:51 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

On 3/5/2013 12:15 AM, Pieter du Plooy wrote:

Stephen

I essentially took the pgrouting4w-master from
https://github.com/sanak/pgrouting4w, and followed the guide from the
Build.mingw file. I had problems building boost, but followed
http://stackoverflow.com/questions/5299468/unable-to-build-boost-libraries-with-gcc
to build bjam and then boost.

I am attaching an winrar file with the dll’s as well as the sql files
which I modified according to Linux procedures as Postgres 9.2 uses
LANGUAGE ‘c’ instead of LANGUAGE ‘C’ .

Pieter,

Thank you for this it will save me a bunch of time once I tackle this.

I would also like the ability to have pgrouting to be installed as
Postgres 9.2 extensions in stead of doing a psql -f on all the sql
files, but I didnt know how to do that, otherwise I also would have done
that.

I have built an extension for some other code, and it is high on my list to get extensions working for pgRouting.

I personally feel the hassles building a 64 bit version outweighs the
pro’s but that’s just me.

I have gone through the process of building postgis on windows 64 bit and it is a bit tedious. I’m hoping that we can get this automated in the future, but we have a lot of other stuff to work on first.

Best regards,
-Steve

Pieter

On Sun, Mar 3, 2013 at 5:51 PM, Stephen Woodbridge

<woodbri@swoodbridge.com mailto:[woodbri@swoodbridge.com](mailto:woodbri@swoodbridge.com)> wrote:

On 3/3/2013 2:49 AM, Pieter du Plooy wrote:

Hi guys

Those who posted in February about PGRouting and Postgresql 9.2,
I have
built pgrouting from github against postgresql 9.2 for Windows
32 bit.

Anyone interested please contact me.

Pieter

Hi Pieter,

Can you send me details on how you did this?

I have build PostGIS 2.0 for Windows 64 and I will be doing the same
for Windows 32 and also will be pgRouting for both of these. I also
hope to get pgRouting to install as an extension under postgresql.

My end result is that I want to check in the build and document this
process and scripts and check it into git so we have a repeatable
process that anyone can replicate for building pgRouting.

Thanks,
-Steve

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.__org
mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)
http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users
<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>

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