[pgrouting-dev] Reg: Compile error in KSP with PostgreSQL 8.4

[Stephen Woodbridge]

Ther already is the ticket for this problem:

https://github.com/pgRouting/pgrouting/issues/301

While I'm willing to accept this is an enhancement request, it is a very 
high priority in my mind because MANY production sites have to support 
multiple versions of postgres and it is a standard supported feature of 
postgresql to be able to run a cluster of multiple versions.

Upgrading the database is not always an option, because some software 
packages require specific versions of the database and users are not 
always in a position to upgrade the software dependencies. It might be 
easy for a developer to do this because they are not running a 
production environment, but ultimately most users that are running a 
production environment, do not have this option because they go through 
an IT department or a service provider and have to rely on them for 
version support.

And more importantly, because it is all about me :), I can't develop and 
test in my environment against 9.2, 9.3, 9.4 that I have installed when 
we need to verify bugs from users, and test against versions locally.

So if Mani can get this working great, and if not I will eventually get 
to it for the next release, and if we have a fix for this, I'll roll it 
into develop so others that need it can get it.

-Steve

On 6/22/2015 12:25 PM, Vicky Vergara wrote:
> Steve, Mani:
>
> I think its a feature request, not a bug.
> I installed in a different partition the OS, and installed postgres 9.1
> and I could install pgrouting on 9.1
>
> So, it installs on 9.4, and 9.1 as long as they are not under the same OS.
>
> While the feature of "supporting multiple postgres versions on the same
> OS" is not implemented, a work around could be to migrate your databases
> from 9.1, 9.2 and 9.3 to 9.4.
>
> btw. issue 109 was closed by Steve and with a comment of will not fix.
>
> ------------------------------------------------------------------------
> Date: Mon, 22 Jun 2015 21:20:05 +0530
> From: mani.iiit123 at gmail.com
> To: pgrouting-dev at lists.osgeo.org
> Subject: Re: [pgrouting-dev] Reg: Compile error in KSP with PostgreSQL 8.4
>
> Hi Steve,
>
> I've tried my best to update cmake/FindPostgreSQL.cmake  and
> CMakeLists.txt, but the build was not successful. I've changed all the
> POSTGRES variables to 9.4, cmake executed properly, but while
> compiling(make) there is a error saying "Postgres.h" not found. Can you
> share your CMakeLists.txt and cmake/FindPostgresql..cmake. I am on the
> version 9.4.
>
> I think this needs to be solved for the next release. We need to the
> pass the postgresql version to build,  like the option you said
> "DUSE_PG=9.x". But unfortunately it is not working right now. I'll try
> to read about cmake and see what I can do. I will update you.
>
> Thank you,
> Mani
>
> On Mon, Jun 22, 2015 at 8:20 PM, Stephen Woodbridge
> <woodbri at swoodbridge.com <mailto:woodbri at swoodbridge.com>> wrote:
>
>     On 6/22/2015 10:37 AM, Manikanta Kondeti wrote:
>
>         Hi,
>
>            I am facing an error while building from source. This is that
>            issue: https://github.com/pgRouting/pgrouting/issues/109
>
>             How to resolve that?  Changing Pg version to 9.1 in
>         CMakeLists.txt is
>         not working. I have 9.1 and 9.4 postgresql versions installed in my
>         system. Help me out in resolving this.
>
>
>     Mani,
>
>     Sorry, the CMakeLists.txt files built for pgrouting 2.x were not
>     designed for support multiple versions installed on the same system.
>     This is a problem for me because I have 9.2, 9.3, and 9.4 installed
>     and I can only build and install on 9.4.
>
>     The solution id to update the CMakeLists.txt and specifically
>     cmake/FindPostgreSQL.cmake which so you can do something like
>
>     cd build
>     cmake -DUSE_PG=9.x ..
>
>     I took a quick look at doing this a while back but
>     cmake/FindPostgreSQL.cmake needs to be replaced and other changes
>     are needed and I didn't have time to make the changes and get it
>     working.
>
>     tools/test-runner.pl <http://test-runner.pl> already support options
>     for pg versions and ports so only the build system is broken in this
>     regard.
>
>     If you want to read up on CMake and get this working a pull request
>     would be great!
>
>     -Steve
>
>     _______________________________________________
>     pgrouting-dev mailing list
>     pgrouting-dev at lists.osgeo.org <mailto:pgrouting-dev at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
>
> _______________________________________________ pgrouting-dev mailing
> list pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>