[pgrouting-users] Problem when running osm2pgrouting

pgRouting pgrouting-users
1

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

2

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

3

OS: Ubuntu 12.04

I have installed pgrouting dependencies using this url https://gist.github.com/djq/2846196

and pgrouting using this tutorial http://pgrouting.org/docs/1.x/install.html

and didn’t use LiveDVD.

Please let me know if any more info is needed.

···

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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

4

Hi Maruf,

Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.
It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.

I don’t know, why it doesn’t work in your case and why you’re missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load “legacy.sql”.
Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:
http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh

So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).
And the hack for osm2pgrouting is from line #138.

Daniel

···

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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

5

Hi Daniel,

I have run the script using bash ./install_pgrouting.sh

Please check a part of output here. Its missing sample data and there are some database issue.

Thanks

Maruf

···

On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.
It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.

I don’t know, why it doesn’t work in your case and why you’re missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load “legacy.sql”.
Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:
http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh

So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).
And the hack for osm2pgrouting is from line #138.

Daniel

On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

OS: Ubuntu 12.04

I have installed pgrouting dependencies using this url https://gist.github.com/djq/2846196

and pgrouting using this tutorial http://pgrouting.org/docs/1.x/install.html

and didn’t use LiveDVD.

Please let me know if any more info is needed.

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

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

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

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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

6

Hi Maruf,

You can’t run this script just as it is, because it uses the same sample data, that has been downloaded by the OSM install script before (different script).
Also OSGeo Live has a an admin user named “user”, so this might not work for you either.

So I would recommend you to just pick the commands you need and change them where necessary. You can use your own OSM data for example, but you probably need to adjust the path then.

Daniel

···

On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.
It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.

I don’t know, why it doesn’t work in your case and why you’re missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load “legacy.sql”.
Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:
http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh

So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).
And the hack for osm2pgrouting is from line #138.

Daniel

On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

OS: Ubuntu 12.04

I have installed pgrouting dependencies using this url https://gist.github.com/djq/2846196

and pgrouting using this tutorial http://pgrouting.org/docs/1.x/install.html

and didn’t use LiveDVD.

Please let me know if any more info is needed.

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

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

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

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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

7

Hi Daniel,

Everything is fine until adding pgrouting core functions. When i try to execute these two command

sudo -u $USER_NAME psql --quiet -f $PGROUTING_FOLDER/routing_core_wrappers.sql $OSM_DB
sudo -u $USER_NAME psql --quiet -f $PGROUTING_FOLDER/routing_topology.sql $OSM_DB

it generates some error. Please see the output.

What is the solution?

Thanks

Maruf

···

On Thu, Feb 21, 2013 at 10:04 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

You can’t run this script just as it is, because it uses the same sample data, that has been downloaded by the OSM install script before (different script).
Also OSGeo Live has a an admin user named “user”, so this might not work for you either.

So I would recommend you to just pick the commands you need and change them where necessary. You can use your own OSM data for example, but you probably need to adjust the path then.

Daniel

On Fri, Feb 22, 2013 at 12:59 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi Daniel,

I have run the script using bash ./install_pgrouting.sh

Please check a part of output here. Its missing sample data and there are some database issue.

Thanks

Maruf

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

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

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

On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.
It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.

I don’t know, why it doesn’t work in your case and why you’re missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load “legacy.sql”.
Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:
http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh

So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).
And the hack for osm2pgrouting is from line #138.

Daniel

On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

OS: Ubuntu 12.04

I have installed pgrouting dependencies using this url https://gist.github.com/djq/2846196

and pgrouting using this tutorial http://pgrouting.org/docs/1.x/install.html

and didn’t use LiveDVD.

Please let me know if any more info is needed.

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

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

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

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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

8

Hi Maruf,

Does you database have PostGIS installed?
Does PostGIS work?

It looks like some PostGIS stuff is missing.
Do you still have your self-compiled PostGIS from the Gist notes?

Daniel

···

On Thu, Feb 21, 2013 at 10:04 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

You can’t run this script just as it is, because it uses the same sample data, that has been downloaded by the OSM install script before (different script).
Also OSGeo Live has a an admin user named “user”, so this might not work for you either.

So I would recommend you to just pick the commands you need and change them where necessary. You can use your own OSM data for example, but you probably need to adjust the path then.

Daniel

On Fri, Feb 22, 2013 at 12:59 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi Daniel,

I have run the script using bash ./install_pgrouting.sh

Please check a part of output here. Its missing sample data and there are some database issue.

Thanks

Maruf

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

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

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

On Thu, Feb 21, 2013 at 9:46 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.
It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.

I don’t know, why it doesn’t work in your case and why you’re missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load “legacy.sql”.
Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:
http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh

So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).
And the hack for osm2pgrouting is from line #138.

Daniel

On Fri, Feb 22, 2013 at 12:31 AM, maruf rahman <maruf.csdu@gmail.com> wrote:

OS: Ubuntu 12.04

I have installed pgrouting dependencies using this url https://gist.github.com/djq/2846196

and pgrouting using this tutorial http://pgrouting.org/docs/1.x/install.html

and didn’t use LiveDVD.

Please let me know if any more info is needed.

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

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

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

Maruf

On Thu, Feb 21, 2013 at 8:59 PM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Maruf,

Can you provide more information?
Like which OS you use, how you installed pgRouting, etc…
Do you use the OSGeo LiveDVD?

Daniel

On Thu, Feb 21, 2013 at 11:38 PM, maruf rahman <maruf.csdu@gmail.com> wrote:

Hi

I am trying to use pgrouting following this tutorial. Currently I am in section 4.2. However when I try to execute the command of section 4.2, it only creates 3 tables name classes, nodes and types. But the document says, it should create 8 tables.

Where is the problem? How can I solve this?

Thanks
Maruf

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

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

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