[Qgis-user] Quantum Connect to PostgreSQL

[Vincent Blanqué]

Hi,

I am joining to this subject because I have just the same problem... I
can't connect since a remote QGis neither Pgadmin.

Do you have a sample of "pg_hba.conf" ?

Can you explain how to know the SSL mode set in our server ?

thx,

Enzo

Andreas Neumann a écrit :
> 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
>>
> 
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: vincent_blanque.vcf
Type: text/x-vcard
Size: 290 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20090914/e54ff46a/attachment.vcf>