Unable to connect Postgis from QGIS 1.8.0

Question

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

I checked the pg_hba.conf file (All default settings)
Restart the PostgreSQL service and tried 
I have reinstalled PostsreSQL and getting same error.
Tried using empty fields while connecting still getting an error. (Not sure what to put in service field..tried using postgres and postgresql)
My firewall is disabled.
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 ??

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

AndreJ · Accepted 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.

Jay Guarneri · Answer

I had this problem recently as well.  What worked for me is:

leaving the host field blank.  "localhost" refers to connecting to
your local machine via IP, which I don't believe is what you want.
look in your postgresql.conf file for

listen_addresses = '*'      # what IP address(es) to listen on;

and make sure that it is an '*', this will ensure it can find your local connection
check your pg_hba.conf file and make sure your authentication permissions are set correctly for the "local" entry

Edit:  Here's a link to my similar question on Database Administrators.

juststarting · Answer

I don't know if this will help but....

I have only just started on this but I found that "localhost" would not resolve on my PC which has similar config/versions to yours.  I replaced it with 127.0.0.1 and I got a successful connection.

Wolf · Answer

You use the port 5433, but the standard port is 5432. Maybe control it.

Jose I Miranda · Answer

The answer is in a post 5 years later, last revised 4 years later! I found it regarding "QGIS Ticket #930". What you MUST do: ONLY check the SAVE username & password in the dialog defining your connection. THAT'S ALL. It worked suddenly for me and I am pretty sure will do for you. My env.: Windows 7 Pro/QGIS 1.8/PostgreSQL 9.2/PostGIS 2.0.2/All of them 64 bits.

Answered by Jose I Miranda on June 9, 2021

jase81 · Answer

You must confirm the database is PostGIS not PostGres

Go to pgAdmin and view your database. Open and view the DB and besides "Schemas" there will be a count of schemas available. If it says "Schemas (1)" it's probably only a PostGres DB. Inside "Schemas" there should be an entry for "topology." If there is no topology it is not a spatial database (PostGIS) and therefore will not be visible in QGIS.

Komby · Answer

Install the latest version and reconnect

Unable to connect Postgis from QGIS 1.8.0

7 Answers

Add your own answers!

Ask a Question