4

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

7

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
  • 1
    oh my goodness this is maybe the most pain an answer on stackexchange has ever spared me
    – Owen
    Jul 15, 2016 at 6:26

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.