On Mon, Oct 24, 2011 at 11:14 PM, Christoph Zwerschke <[email protected]> wrote: > Am 25.10.2011 02:58, schrieb Aleksey Tsalolikhin: >> >> Our python program does have multiple threads, but each thread is supposed >> to set up its own connection to Postgres. > > If that's the case, PyGres should work fine for you. Also, your program > seems to hang where Python is acquiring a lock, but PyGres doesn't do that > (actually that's the very reason why it is not thread-safe). So I suppose > it's some other component of your system.
Thank you, it turned out we were (inadvertently) running four instances of this program, and it is supposed to be one instance only, and we were exhausting the TCP ports on the system. We are going to add some logic/locking to the program to make sure only one instance runs at a time. Thanks, Aleksey _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
