I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
In your first email you wrote, that you created a database first. But the database creation is actually part of SQL dump file already.
You can also just login to some other database and then run “\i path/to/sampledata_notopo.sql”
Inside this file it creates the database like this:
So it is looking for a “template_routing” template database, that was mentioned in a previous chapter.
The errors you posted you need to debug from top. So first it complains about already existing database and second about missing “geometry” things. When using the template database it should work.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
I have reinstalled everything and started from scratch. However when i execute this command psql -d routing -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql
In your first email you wrote, that you created a database first. But the database creation is actually part of SQL dump file already.
You can also just login to some other database and then run “\i path/to/sampledata_notopo.sql”
Inside this file it creates the database like this:
So it is looking for a “template_routing” template database, that was mentioned in a previous chapter.
The errors you posted you need to debug from top. So first it complains about already existing database and second about missing “geometry” things. When using the template database it should work.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.
I have reinstalled everything and started from scratch. However when i execute this command psql -d routing -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql
You look at the first error and it already tells you the problem:
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql:59: ERROR: type "spheroid" already exists
So you already have PostGIS added to your database.
Also it seems you’re using PostGIS 2.0 and PostgreSQL 9.1, so you can install PostGIS much easier with “CREATE EXTENSION postgis”.
Be aware that the workshop was written when no PostGIS 2.0 was available yet. So simple copy & paste might not work every time.
Furthermore the sample data in dump files (such as notopo.sql) where created with an older version of PostgreSQL.
This can be a reason why things don’t work.
In your first email you wrote, that you created a database first. But the database creation is actually part of SQL dump file already.
You can also just login to some other database and then run “\i path/to/sampledata_notopo.sql”
Inside this file it creates the database like this:
So it is looking for a “template_routing” template database, that was mentioned in a previous chapter.
The errors you posted you need to debug from top. So first it complains about already existing database and second about missing “geometry” things. When using the template database it should work.
Could be that this version of the workshop is outdated as it’s the one from FOSS4G 2010.
Can you try the workshop FOSS4G 2011 instead?
The most up-to-date content is always the online version: http://workshop.pgrouting.org/
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.