I'm trying to connect to a new local PostGIS instance (PostgreSQL.app on mac) with QGIS 2.0, and it gives general connection errors.

Connection with same parameters with other clients (psql, PGAdmin) is ok, with both socket and port, so it can't be server configuration?


After wasting several hours it turns out that QGIS cannot connect to an empty database, and Postgres.app ships with one.

Solution was to initialize PostGIS in the database in psql with create extension postgis;

and then connection was successful.

  • 1
    oh my goodness this is maybe the most pain an answer on stackexchange has ever spared me – Owen Jul 15 '16 at 6:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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