[postgis-users] Postgres Timeouts

Aaron Edwards aedwards at b3insight.com
Wed Apr 11 08:39:07 PDT 2018


My ETL process requires that I issue several long-running queries to postgresql.  Queries like building indexes, updating SRIDs, that kind of thing.

My problem is that if the query takes too long to run, something over 5 minutes (but I don't know the actual number for certain), then the query never returns.  I've set the ConnectionTimeout property of the connection to 0, which I understand is no timeout.  But the command is timing out anyway.  Often times I can see that the command has completed successfully, by looking for the presence of the objects the command is creating in pg Admin.  But the script still hangs, because as far as it knows, postres is still processing it's previous command.

Is there a default timeout setting that is global to a postgresql database or server?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180411/5552a7bb/attachment.html>

More information about the postgis-users mailing list