Hi, I have a script that runs a query on a remote server. The query will take quite some time to finish. Now the problem is that the tcp stack will timeout before the query is finished. I am running the query as async and have a loop where I query the pg_ready status every 5 seconds. Is there anyway to send some NOOP or anything so this connection does not timeout? Just reading pg_ready seems to do nothing, probably because it gets filled once the query is done. Running the query as not async has the same issues with timeout. -- â Clemens å Schwaighofer â IT Engineer/Web Producer/Planning â E-Graphics Communications SP Digital â 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN â Tel: +81-(0)3-3545-7706 â Fax: +81-(0)3-3545-7343 â http://www.e-gra.co.jp -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
