pgRoutingLayer does not show the database connected.

QGIS: 2.14.15 and pgAdmin III

CREATE EXTENSION postgis; (ok)

CREATE EXTENSION pgrouting; (ok)

SELECT pgr_version(); (2.0.0,pgrouting-2.0.0,0,d6ed2cb,master,1.53.0) (ok)

DB Manager

pgAdmin III


DB Manager tables

enter image description here

How to solve this?

  • Did you configure the database connection in QGIS? Can you see your data?
    – dkastl
    Sep 13, 2017 at 3:11
  • I think I followed all the steps to complete the creation and connection of the database (teste_01), both in pdAdmin III and in QGIS. Please see the figures added. I can see the data.
    – Sergio
    Sep 13, 2017 at 6:27
  • You don't have a QGIS database connection, it seems. This is not a pgRouting issue. First try to show your road network as a PostGIS layer in QGIS. If that works, then proceed with the pgrouting plugin.
    – dkastl
    Sep 13, 2017 at 11:05
  • I think I have a connection to the test_01 database because when I right click on (DB Manager) newark_splited_1, newark_splitted_1_vertices_pgr, and students, and then, I click Add to Canvas all of them are shown as layers in QGIS, as you can see above. However the database test_01 still does not appear in the pgRouting panel. More information: I created and saved a project in QGIS with these layers. When I reload this project in QGIS, the name and password of the database are asked.
    – Sergio
    Sep 13, 2017 at 12:34
  • QGIS 2.14.15 was replaced by QGIS 2.14.18 (deleting user\me\.qgis2 and the registry entries for QGIS, by running the regedit program). But the problem persists.
    – Sergio
    Sep 15, 2017 at 19:30

1 Answer 1


The database connection users and password must be

  • saved
  • saved as 'basic' --> Not as a configuration

Save your password

Your Answer

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

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