Re: [GENERAL] Applications that leak connections

2005-02-04 Thread Paul Tillotson
Correct me if I am wrong, but doesn't the postmaster notice that something killed a backend and cause all the other ones to roll back? Paul Tillotson Neil Conway wrote: Paul Tillotson wrote: Does anyone know a safe way to shutdown just one backend Sending it a SIGTERM via kill(1) should be safe.

Re: [GENERAL] Applications that leak connections

2005-02-04 Thread Neil Conway
Paul Tillotson wrote: Does anyone know a safe way to shutdown just one backend Sending it a SIGTERM via kill(1) should be safe. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail c

Re: [GENERAL] Applications that leak connections

2005-02-03 Thread Jonel Rienton
you are perfectly right, fixing the source of the problem is the best way to fix this. i always make it a habit to close my connections as soon as i'm done with it. if foxpro won't do it for you, you have to manage your own resources, always a good practice for unmanaged applications. i suggest

[GENERAL] Applications that leak connections

2005-02-03 Thread Paul Tillotson
Does anyone have any useful info about dealing with applications which "leak" connections, eventually causing "connection limit exceeded for non superusers?" Obviously fixing the app is the best choice, but I have a feeling that this is going to recur again and again since the app is poorly ma