Yeah, my dbt2 applications are multithreaded.Do you need SIGPIPE delivery in your app? If no, could you try what happens if you apply the attached patch to postgres, and perform the
signal(SIGPIPE, SIG_IGN);
once in your dbt2 app?
-- Manfred
--- pgsql.orig/src/interfaces/libpq/fe-secure.c 2003-11-01 22:28:13.000000000 +0100
+++ pgsql/src/interfaces/libpq/fe-secure.c 2003-11-01 22:27:21.000000000 +0100
@@ -348,7 +348,7 @@
ssize_t n;
#ifndef WIN32
- pqsigfunc oldsighandler = pqsignal(SIGPIPE, SIG_IGN);
+/* pqsigfunc oldsighandler = pqsignal(SIGPIPE, SIG_IGN); */
#endif
#ifdef USE_SSL
@@ -408,7 +408,7 @@
n = send(conn->sock, ptr, len, 0);
#ifndef WIN32
- pqsignal(SIGPIPE, oldsighandler);
+/* pqsignal(SIGPIPE, oldsighandler); */
#endif
return n;
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
