Skip to main content
Question

Timeout / Postgis-Writer

  • March 23, 2017
  • 5 replies
  • 21 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
  • March 23, 2017

I don't think that's possible.


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • March 23, 2017

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
  • March 24, 2017
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+18
  • Supporter
  • March 24, 2017
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
  • March 24, 2017
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.