2

I tried to install pgrouting on Ubuntu 16.04 but I got following error message:

CREATE EXTENSION pgrouting;

could not open extension control file "/opt/PostgreSQL/9.6/share/postgresql/extension/pgrouting.control": file or directory not found

I downloaded the EnterprisDB Postgres(9.6) Bundle, installed postgres ant then installed PostGis using the stackbuilder. I was able to create the PostGis extension and the topology extension. Some other extensions like pgrouting fail to install.

Does anyone know why intallation of some extensions fail?

I did the same on Win10 a few days ago an everything worked.

Improve this question
1
  • Don't use EnterpriseDb Postgre 9.6 Linux if you want pgRouting. Use PostgreSQL Apt as dkastl noted in his answer. The EDB windows stackbuilder is the only EDB version at this time that contains pgRouting because I package that one.
    – LR1234567
    Apr 27, 2017 at 15:46

1 Answer 1

Reset to default
3

Because pgRouting can be installed as Ubuntu package from the PostgreSQL Apt repository, the easiest way is to add this repository and then run 

sudo apt-get install postgresql-9.6-pgrouting

How to add the PostgreSQL Apt repository is described here: https://www.postgresql.org/download/linux/ubuntu/

I don't know what "stackbuilder" means for Ubuntu, because I only try installation via package manager, but in case you have installed another version of PostgreSQL, too, make sure that:

  • you are using the PostgreSSQL 9.6 (and not the other version)
  • you have installed pgRouting for PostgreSQL 9.6
Improve this answer
4

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.