Postgres Pro
Downloads
Home   >   mailing lists

psycopg2 conn.poll() hangs when used with sshtunnel - Mailing list psycopg

From Akshay Joshi
Subject psycopg2 conn.poll() hangs when used with sshtunnel
Date
Msg-id CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com
Whole thread Raw
Responses Re: psycopg2 conn.poll() hangs when used with sshtunnel  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List psycopg
Tree view

Hello

I am using psycopg2 2.7.4 to connect to the PostgreSQL database server using asynchronoussupport. It is working absolutely fine. I have used sshtunnel v0.1.3 in pgAdmin4. When I connect the PostgreSQL database server using ssh tunnel and run the valid/correct query it works fine, but when I run any wrong query(invalid column of table) my application gets hang on conn.poll() function.

Please refer the code how we use conn.poll() with timeouts https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=web/pgadmin/utils/driver/psycopg2/connection.py;h=4f11c12b30882209c308cb3558e67189c97ea31e;hb=15fe26a7106610b710f3de5b604cd038302c926a#l1363

Can anyone please provide some pointers, suggestions?


--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

psycopg by date:

Previous
From: Federico Di Gregorio
Date:
Subject: Re: Integration of Psycopg with XTA
Next
From: Christian Ferrari
Date:
Subject: Re: Integration of Psycopg with XTA