Sharing database handles across forked child processes

Поиск
Список
Период
Сортировка
Искать
От
dan@sidhe.org
Тема
Sharing database handles across forked child processes
Дата
Msg-id
52562.199.172.169.21.1194973351.squirrel@localhost
Список
Дерево обсуждения
Sharing database handles across forked child processes dan@sidhe.org
Re: Sharing database handles across forked child processes Martijn van Oosterhout <kleptog@svana.org>
Re: Sharing database handles across forked child processes Tom Lane <tgl@sss.pgh.pa.us>
Re: Sharing database handles across forked child processes dan@sidhe.org
Re: Sharing database handles across forked child processes Martijn van Oosterhout <kleptog@svana.org>
Re: Sharing database handles across forked child processes "Greg Sabino Mullane" <greg@turnstep.com>
Re: Sharing database handles across forked child processes dan@sidhe.org
Re: Sharing database handles across forked child processes Vivek Khera <vivek@khera.org>
How does Postgres handle sharing database handles across child processes?
That is, if I have a process that opens a connection to the database and
then forks a few child processes, what happens?


Can the child processes safely use the handle?


If one child closes the handle, what happens to the handle in all the
other children? The parent?

This isn't a great thing to do, I realize, but I'm wedging database access
into an existing heavily fork-bound perl program, so my hands are somewhat
tied architecturally. (If it means I have to constantly test to see if the
handle's valid, and may have to deal with a handle randomly going away on
me, I can handle that -- I'm more worried about data corruption and
deadlock problems here, stuff I can't reasonably catch at the application
level)

-Dan


В списке pgsql-general по дате отправления
От: SHARMILA JOTHIRAJAH
Дата:
Сообщение: Postgres table size
От: Martijn van Oosterhout
Дата:
FAQ