7

It seems pretty clear I cannot connect to a local postgresql installation out of QGIS. This is my first experience with PostGIS. I am using PostgreSQL 9.0 on a win7 machine. I can see the successful installation of Postgresql and the postgis database in both PGAdmin and NaviCat. I have added a user account in PGAdmin which is not a superuser (meaning I believe I have dealt with the issues discussed at http://pgsnake.blogspot.com/2010/07/postgresql-passwords-and-installers.html).

Has something changed on QGIS 1.7?

After I choose to Add Postgis Layer, I specify a new connection which resembles my configuration and is consistent with http://www.gistutor.com/quantum-gis/20-intermediate-quantum-gis-tutorials/34-working-with-your-postgis-layers-using-quantum-gis-qgis.html and the Linfinity blog. I have toggled SSL mode after reading http://osgeo-org.1803224.n2.nabble.com/Postgis-SSL-connection-td2037146.html.

The failure in the test connection leads to "ERROR:service file "/etc/pg_service.conf" not found".

Has anyone got some more positive experience with PostgreSQL, QGIS and Win7?

Improve this question
1
  • darn! i had the same issue.
    – George Silva
    Commented Feb 13, 2012 at 18:20

1 Answer 1

Reset to default
11

The service parameter in the QGIS/PostGIS dialog should be empty. And I spent a bit of time killing the user account "postgres" in windows and removing the names of the databases which are created in the windows registry. After that I could repeatedly fail the dialog by having something in the service parameter of the QGIS Postgis connection dialog.

Improve this answer
1
  • 2
    GIS SE wants me to wait a few hours till I can do this...
    – BWill
    Commented Jul 11, 2011 at 11:21

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.