[Qgis-user] Quantum Connect to PostgreSQL

Andreas Neumann a.neumann at carto.net
Sun Sep 13 23:35:05 PDT 2009


also make sure that the SSL mode setting is correct - not to mention
user/pw of course ...

Can you connect from other machines with other software (e.g. pgadmin3)
using the same settings?

Andreas


On Mon, September 14, 2009 5:42 am, pcreso at pcreso.com wrote:
> Hi Chris,
>
> Have you enabled TCP/IP access in pg_hba.conf?
>
> QGIS uses a network socket connection whether or not it is on a local
> host, so Postgres needs to enable such connections.
>
>
> Brent Wood
>
>
> --- On Mon, 9/14/09, chris Wild <chrismwild at gmail.com> wrote:
>
>> From: chris Wild <chrismwild at gmail.com>
>> Subject: [Qgis-user] Quantum Connect to PostgreSQL
>> To: qgis-user at lists.osgeo.org
>> Date: Monday, September 14, 2009, 3:29 PM
>> Dear All
>>
>> We are trying to set up a Quantum connection to a POSTGIS
>> database using Port 5432.
>>
>> The connection comes back "Refused" each time. We
>> have also tried an ODBC driver based connection to the
>> database and it also is refused.
>>
>>
>> The exact message is:
>>
>> The database said:
>> Could not connect to server: Connection Refused
>>
>> All firewalls are open for  Port 5432 and the server
>> router is logging packets getting through it.
>>
>> Can anyone help?
>>
>>
>> Best Wishes
>>
>>
>> Tony Lindsay
>>
>>
>>
>> -----Inline Attachment Follows-----
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
Andreas Neumann
http://www.carto.net/neumann/
http://www.svgopen.org/




More information about the Qgis-user mailing list