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?

1 Answer 1


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
    Commented Jul 15, 2016 at 6:26

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.