Opened 9 years ago
Closed 9 years ago
#1281 closed defect (fixed)
|Reported by:||kalxas||Owned by:|
ldconfig deferred processing now taking place E: Package 'osm2pgrouting' has no installation candidate create pgrouting database with PostGIS and pgRouting createdb: database creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) HINT: Use the same encoding as in the template database, or use template0 as template. psql: FATAL: database "pgrouting" does not exist psql: FATAL: database "pgrouting" does not exist unpack sample data Run osm2pgrouting converter (this may take a while) sudo: osm2pgrouting: command not found psql: FATAL: database "pgrouting" does not exist
Change history (15)
comment:1 by , 9 years ago
comment:2 by , 9 years ago
|Status:||new → assigned|
comment:3 by , 9 years ago
comment:4 by , 9 years ago
You can get the package from this repository: https://launchpad.net/~georepublic/+archive/pgrouting
comment:5 by , 9 years ago
Thanks dkastl, I copied the deb package. Testing on next nightly
comment:6 by , 9 years ago
in  :
Unpacking osm2pgrouting (from .../osm2pgrouting_2.0.0-release-ppa1~precise1_i386.deb) ... Setting up osm2pgrouting (2.0.0-release-ppa1~precise1) ... create pgrouting database with PostGIS and pgRouting CREATE EXTENSION CREATE EXTENSION unpack sample data Run osm2pgrouting converter (this may take a while) sudo: osm2pgrouting: command not found VACUUM
comment:7 by , 9 years ago
|Status:||assigned → new|
comment:8 by , 9 years ago
I would really appreciate, if the person, who commented out the previous PPA for pgRouting also makes sure, that the install script still works.
It would have been quite easy then to see, that osm2pgrouting was not copied to the OSGeoLive PPA.
So possible solutions are:
- (1) Re-enable the PPA with osm2pgrouting (ppa:georepublic/pgrouting)
- (2) Copy the osm2pgrouting package to the PPA, which is used now.
(1) I can do, (2) I can't.
For reference the relevant lines in "install_pgrouting.sh":
# TODO: Remove third party PPAs #add-apt-repository -y ppa:georepublic/pgrouting apt-get update -qq # Install pgRouting packages apt-get install -y -qq postgresql-9.3-pgrouting if [ $? -ne 0 ] ; then echo 'ERROR: pgRouting Package install failed! Aborting.' exit 1 fi # Install osm2pgrouting package apt-get install -y -qq osm2pgrouting
comment:9 by , 9 years ago
The problem is that the deb was copied several weeks ago and osm2pgrouting still is not picked up
https://launchpad.net/~osgeolive/+archive/nightly/+sourcepub/3889394/+listing-archive-extra "Published on 2014-02-03"
comment:10 by , 9 years ago
Does the ppa:georepublic/pgrouting use PostgreSQL 9.3 as a build target? If not solution (1) is not an option.
comment:11 by , 9 years ago
It seems I found out where the problem lies: osm2pgrouting binary goes to /usr/share/bin and not /usr/bin
I will publish an updated package in the next hours.
comment:12 by , 9 years ago
comment:13 by , 9 years ago
An updated package of osm2pgrouting has been published in "ppa:georepublic/pgrouting" and can be copied into OSGeoLive nightly builds PPA.
It should fix this ticket.
comment:14 by , 9 years ago
Files copied. Thanks. Waiting for next nightly now.
comment:15 by , 9 years ago
|Status:||new → closed|
Fixed in 
@hamish, welcome back :)