[GIS] Unable to connect Postgis from QGIS 1.8.0

postgis-2.0postgresqlqgis

I have installed PostgreSQL and PostGIS on my laptop (Win 7 64 bit OS). I am running QGIS 1.8.0 on my machine .

When I am trying to connect Postgis I am getting connection failed error then I tried following things :

Details:

Port :5433 User name : postgres Password :postgres

  1. I checked the pg_hba.conf file (All default settings)

  2. Restart the PostgreSQL service and tried

  3. I have reinstalled PostsreSQL and getting same error.

  4. Tried using empty fields while connecting still getting an error. (Not sure what to put in service field..tried using postgres and postgresql)

  5. My firewall is disabled.

  6. The database PostgreSQL (version 9.2) is installed on my local machine also postgis (version 2.0.3-2) installed on my machine and both are for 64 bit setups.

7.Should I try lower version of Postgresql with qGIS ??

Screenshot 1 screenshot 2

Researching on Google also and found similar bugs related to connection issue(not sure)

Best Answer

I am not sure if it matters, but for me, Postgis 1.5 and Postgres 9.0 (x86) are talking to QGIS 1.8.0 without problems.

QGIS is still 32-bit, even on Windows 7 64-bit machines. Give the x86 version a try, and the old postgis version.

Related Question