Skip to main content
Question

Timeout / Postgis-Writer

  • Mar 23, 2017 2:26 PM UTC
  • 5 replies
  • 52 views

Forum|alt.badge.img

Hi ,

is it possible to set a timeout-Parameter for writing in a Postgis-DB to ensure, that the connection will be closed.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

david_r
Celebrity
  • Mar 23, 2017 3:45 PM UTC

I don't think that's possible.


itay
Supporter
Forum|alt.badge.img+19
  • Supporter
  • Mar 23, 2017 4:32 PM UTC

I don't think that's possible.

suspected as much, wont it automatically be closed when the writting is ended?

 

 


Forum|alt.badge.img
  • Author
  • Mar 24, 2017 6:14 AM UTC
suspected as much, wont it automatically be closed when the writting is ended?

 

 

yes, connction closed when writing ended. But if there is a problem at the postgis-db during writing, the connection will not be closed.

 

 


itay
Supporter
Forum|alt.badge.img+19
  • Supporter
  • Mar 24, 2017 8:26 AM UTC
yes, connction closed when writing ended. But if there is a problem at the postgis-db during writing, the connection will not be closed.

 

 

Makes sense since then the writing will try to continue.

 

 


Forum|alt.badge.img
  • Author
  • Mar 24, 2017 8:40 AM UTC
Makes sense since then the writing will try to continue.

 

 

I understand, but it would be great, if I can define a timeout, so the connection closed if there is no activity for a long time.

 

Because if I want to run skripts on the Postgsi-db to repair the table. The Skript didn't start, because there are still connections open.