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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 8 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedNov 13, '07 at 5:02p
activeNov 13, '07 at 7:56p
posts8
users5
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2019 Grokbase