[pgrouting-users] pgRouting Debian Package

Christophe_Damour · October 13, 2011, 4:00pm

Hi,

I am trying to convince my hosting provider (alwaysdata) to give me the ability to activate pgRouting in my PostgreSQL / PostGIS database.
His answer is : I can't because there is no readymade Debian package for pgRouting.
Does such a package already exists, or could it be possible to provide one ?

Thanks for any hints,

--
Christophe DAMOUR (SIGéal)

dkastl · October 13, 2011, 4:05pm

On Fri, Oct 14, 2011 at 1:00 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi,

I am trying to convince my hosting provider (alwaysdata) to give me the ability to activate pgRouting in my PostgreSQL / PostGIS database.
His answer is : I can’t because there is no readymade Debian package for pgRouting.
Does such a package already exists, or could it be possible to provide one ?

There are Ubuntu packages available in a Launchpad repository: https://launchpad.net/~georepublic/+archive/pgrouting
It shouldn’t be very difficult to build Debian packages based on them with some small modifications.

Daniel

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Christophe_Damour · October 13, 2011, 4:17pm

Yes, Daniel, I saw these Ubuntu packages, but as I am neither a Debian user nor a Ubuntu one, I can hardly handle this.
That is why I send a SOS to the users / dev community…

···

--
Christophe

On Fri, Oct 14, 2011 at 1:00 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi,

I am trying to convince my hosting provider (alwaysdata) to give me the ability to activate pgRouting in my PostgreSQL / PostGIS database.
His answer is : I can’t because there is no readymade Debian package for pgRouting.
Does such a package already exists, or could it be possible to provide one ?

There are Ubuntu packages available in a Launchpad repository: https://launchpad.net/~georepublic/+archive/pgrouting
It shouldn’t be very difficult to build Debian packages based on them with some small modifications.

Daniel

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

dkastl · October 13, 2011, 4:25pm

On Fri, Oct 14, 2011 at 1:17 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Yes, Daniel, I saw these Ubuntu packages, but as I am neither a Debian user nor a Ubuntu one, I can hardly handle this.
That is why I send a SOS to the users / dev community…

I see. Well, if it’s easy or not depends probably on the Debian version you need the packages for, and the versions of required packages.
From my experience building the packages for Ubuntu there are versions it was a quite easy tasks, and some where I had troubles with dependencies.

Another question is, if your hosting provider requires an “official” Debian package available in a package repository, or if it can be an individually build.

Daniel

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Christophe_Damour · October 13, 2011, 5:11pm

It’s a Debian Lenny (5.0).
I suppose an “official” Debian package would be required, because of maintenance ease for the hosting provider…
Another issue is that this hosting provider uses PostgreSql V9, with which pgRouting is not compatible so far.

···

--
Christophe DAMOUR (SIGéal)

On Fri, Oct 14, 2011 at 1:17 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Yes, Daniel, I saw these Ubuntu packages, but as I am neither a Debian user nor a Ubuntu one, I can hardly handle this.
That is why I send a SOS to the users / dev community…

I see. Well, if it’s easy or not depends probably on the Debian version you need the packages for, and the versions of required packages.
From my experience building the packages for Ubuntu there are versions it was a quite easy tasks, and some where I had troubles with dependencies.

Another question is, if your hosting provider requires an “official” Debian package available in a package repository, or if it can be an individually build.

Daniel

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

Christophe_Damour · October 14, 2011, 3:59pm

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?
Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

Thanks,

···

--
Christophe DAMOUR (SIGéal)

It’s a Debian Lenny (5.0).
I suppose an “official” Debian package would be required, because of maintenance ease for the hosting provider…
Another issue is that this hosting provider uses PostgreSql V9, with which pgRouting is not compatible so far.
Le 13/10/2011 18:25, Daniel Kastl a écrit :

--
Christophe DAMOUR (SIGéal)

On Fri, Oct 14, 2011 at 1:17 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Yes, Daniel, I saw these Ubuntu packages, but as I am neither a Debian user nor a Ubuntu one, I can hardly handle this.
That is why I send a SOS to the users / dev community…

I see. Well, if it’s easy or not depends probably on the Debian version you need the packages for, and the versions of required packages.
From my experience building the packages for Ubuntu there are versions it was a quite easy tasks, and some where I had troubles with dependencies.

Another question is, if your hosting provider requires an “official” Debian package available in a package repository, or if it can be an individually build.

Daniel

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

dkastl · October 14, 2011, 4:41pm

On Sat, Oct 15, 2011 at 12:59 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?

Theoretically it is possible, but since most of my community work is on a volunteer base, I can only do this if I have enough spare time or if you’re able to sponsor the work or find a sponsor.

Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

I use mainly Ubuntu and the new version that was released yesterday, should include PostgreSQL 9.0 as far as I remember.
So I’m also interested to make it work with 9.0 and will probably build packages for 11.10 in the next weeks. If it works with Ubuntu, it should also be compatible with PostgreSQL on Debian.

Daniel

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Christophe_Damour · December 9, 2011, 3:19pm

Hi Daniel,

I am in the process of setting a virtual private server for my development needs.
As I can chose the linux distribution, I would like to know if you manage to build a pgRouting package for PostgreSQL 9.0 ?

Thanks,

···

--
Christophe

On Sat, Oct 15, 2011 at 12:59 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?

Theoretically it is possible, but since most of my community work is on a volunteer base, I can only do this if I have enough spare time or if you’re able to sponsor the work or find a sponsor.

Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

I use mainly Ubuntu and the new version that was released yesterday, should include PostgreSQL 9.0 as far as I remember.
So I’m also interested to make it work with 9.0 and will probably build packages for 11.10 in the next weeks. If it works with Ubuntu, it should also be compatible with PostgreSQL on Debian.

Daniel

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

dkastl · December 9, 2011, 4:01pm

On Sat, Dec 10, 2011 at 12:19 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi Daniel,

I am in the process of setting a virtual private server for my development needs.
As I can chose the linux distribution, I would like to know if you manage to build a pgRouting package for PostgreSQL 9.0 ?

Hi Christophe,

I have build packages for Ubuntu 11.10 with PostgreSQL 9.1, but haven’t published them yet on Launchpad.
And on OpenSuse 11.4 with PostgreSQL 9.0 it was also possible to compile pgRouting.
So I assume that PostgreSQL 9.0 and 9.1 are both OK.

For CGAL dependency on the latest Ubuntu you need this fix:
https://github.com/sanak/pgrouting/commit/6ec1672f79f7070c60fb6095342d7d0b55cf2659

Daniel

Thanks,
--
Christophe
Le 14/10/2011 18:41, Daniel Kastl a écrit :
On Sat, Oct 15, 2011 at 12:59 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?

Theoretically it is possible, but since most of my community work is on a volunteer base, I can only do this if I have enough spare time or if you’re able to sponsor the work or find a sponsor.

Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

I use mainly Ubuntu and the new version that was released yesterday, should include PostgreSQL 9.0 as far as I remember.
So I’m also interested to make it work with 9.0 and will probably build packages for 11.10 in the next weeks. If it works with Ubuntu, it should also be compatible with PostgreSQL on Debian.

Daniel

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Christophe_Damour · December 10, 2011, 10:20am

Hi Daniel,

I got the server up with Ubuntu 11.04.
I tried the following with no success :

Installation following pgRouting doc (http://www.pgrouting.org/docs/1.x/install_ubuntu.html)
It failed at step 2 (Comile pgRouting core), saying it couldn’t find POSTGRESQL_EXECUTABLE…
The postgresql executable path seems to be : /usr/lib/postgresql/8.4/bin
Intallation of your pgRouting package (postgresql-8.4-pgrouting_1.05-1~natty2_i386.deb)
It failed saying postgresql-8.4-postgis is not installed.
I installed indeed postgresql-8.4 (apt-get install postgresql-8.4), but when I try apt-get install postgresql-8.4-postgis, I get a “postgresql-8.4-postgis is not available” message.

As you understand, I am quite a linux newbie, so I apologize for stupid questions…

Any hint appreciated.

···

--
Christophe

On Sat, Dec 10, 2011 at 12:19 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi Daniel,

I am in the process of setting a virtual private server for my development needs.
As I can chose the linux distribution, I would like to know if you manage to build a pgRouting package for PostgreSQL 9.0 ?

Hi Christophe,

I have build packages for Ubuntu 11.10 with PostgreSQL 9.1, but haven’t published them yet on Launchpad.
And on OpenSuse 11.4 with PostgreSQL 9.0 it was also possible to compile pgRouting.
So I assume that PostgreSQL 9.0 and 9.1 are both OK.

For CGAL dependency on the latest Ubuntu you need this fix:
https://github.com/sanak/pgrouting/commit/6ec1672f79f7070c60fb6095342d7d0b55cf2659

Daniel
Thanks,
--
Christophe
Le 14/10/2011 18:41, Daniel Kastl a écrit :
On Sat, Oct 15, 2011 at 12:59 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?

Theoretically it is possible, but since most of my community work is on a volunteer base, I can only do this if I have enough spare time or if you’re able to sponsor the work or find a sponsor.

Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

I use mainly Ubuntu and the new version that was released yesterday, should include PostgreSQL 9.0 as far as I remember.
So I’m also interested to make it work with 9.0 and will probably build packages for 11.10 in the next weeks. If it works with Ubuntu, it should also be compatible with PostgreSQL on Debian.

Daniel

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

dkastl · December 10, 2011, 2:08pm

Hi Christophe,

Here is a link to the workshop documentation: http://workshop.pgrouting.org/chapters/installation.html#pgrouting
Like this pgRouting is also installed on the OSGeo LiveDVD, where postgresql-8.4-postgis is installed as well.

Can you make sure that you have the “multiverse” repository enabled? It could be the reason, that you can’t find PostGIS package.

Daniel

On Sat, Dec 10, 2011 at 7:20 PM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi Daniel,

I got the server up with Ubuntu 11.04.
I tried the following with no success :

Installation following pgRouting doc (http://www.pgrouting.org/docs/1.x/install_ubuntu.html)
It failed at step 2 (Comile pgRouting core), saying it couldn’t find POSTGRESQL_EXECUTABLE…
The postgresql executable path seems to be : /usr/lib/postgresql/8.4/bin

Intallation of your pgRouting package (postgresql-8.4-pgrouting_1.05-1~natty2_i386.deb)
It failed saying postgresql-8.4-postgis is not installed.
I installed indeed postgresql-8.4 (apt-get install postgresql-8.4), but when I try apt-get install postgresql-8.4-postgis, I get a “postgresql-8.4-postgis is not available” message.

As you understand, I am quite a linux newbie, so I apologize for stupid questions…

Any hint appreciated.
--
Christophe
Le 09/12/2011 17:01, Daniel Kastl a écrit :
On Sat, Dec 10, 2011 at 12:19 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

Hi Daniel,

I am in the process of setting a virtual private server for my development needs.
As I can chose the linux distribution, I would like to know if you manage to build a pgRouting package for PostgreSQL 9.0 ?

Hi Christophe,

I have build packages for Ubuntu 11.10 with PostgreSQL 9.1, but haven’t published them yet on Launchpad.
And on OpenSuse 11.4 with PostgreSQL 9.0 it was also possible to compile pgRouting.
So I assume that PostgreSQL 9.0 and 9.1 are both OK.

For CGAL dependency on the latest Ubuntu you need this fix:
https://github.com/sanak/pgrouting/commit/6ec1672f79f7070c60fb6095342d7d0b55cf2659

Daniel
Thanks,
--
Christophe
Le 14/10/2011 18:41, Daniel Kastl a écrit :
On Sat, Oct 15, 2011 at 12:59 AM, “Christophe Damour (SIGéal)” <sigeal@sigeal.com> wrote:

I asked the provider and he answered that an official Debian package was not absolutely required, but at least a package supported by pgRouting development team. Could this be possible ?

Theoretically it is possible, but since most of my community work is on a volunteer base, I can only do this if I have enough spare time or if you’re able to sponsor the work or find a sponsor.

Also, what about PostgreSql 9 compatibility. Is this on the roadmap ?

I use mainly Ubuntu and the new version that was released yesterday, should include PostgreSQL 9.0 as far as I remember.
So I’m also interested to make it work with 9.0 and will probably build packages for 11.10 in the next weeks. If it works with Ubuntu, it should also be compatible with PostgreSQL on Debian.

Daniel

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de
_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de