Zdenek Kotala wrote: > When postgreSQL is compiled with --thread-safe that libpq should be > thread safe. But it is not true when somebody call fork(). The problem > is that fork() forks only active threads and some mutex can stay locked > by another thread. We use ssl_config mutex which is global. > > We need implement atfork handlers to fix this. See > http://www.opengroup.org/onlinepubs/009695399/functions/pthread_atfork.html > > We should add pthread_atfork into _ini libpq section. > > Another problem with fork is that new process inherit connections and so > on. Which is not also good, but it is happened also on single threaded > application and developer can fix it in own code. Maybe some notice in > documentation should help what application should do after fork.
Yep, added to TODO list: Make libpq thread-safe in programs that use fork() This requires the use of pthread_atfork() to release global locks held in libpq * http://archives.postgresql.org/pgsql-hackers/2009-04/msg00747.php -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers