Skip to main content
Question

Timeout / Postgis-Writer


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.

david_r
Evangelist

I don't think that's possible.


itay
Contributor
Forum|alt.badge.img+16
  • Contributor
  • March 23, 2017
david_r wrote:

I don't think that's possible.

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

 

 


Forum|alt.badge.img
itay wrote:
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
Contributor
Forum|alt.badge.img+16
  • Contributor
  • March 24, 2017
barbara wrote:
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
itay wrote:
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.

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings