Re: Using connection after fork - Mailing list pgsql-general

From Tom Lane
Subject Re: Using connection after fork
Date
Msg-id 29320.1092156685@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using connection after fork  (Jeff <threshar@torgo.978.org>)
List pgsql-general
Jeff <threshar@torgo.978.org> writes:
> I've been bit by this sort of thing before.  When you fork() the child
> inherits all the file descriptors , including the one connected to PG.
> But when the child dies  that FD will be closed, thus it will also be
> closed in the parent causing "odd behavior".   (At least, that is what
> I've seen in my apps)

That would only happen if the child explicitly does PQfinish() before
exiting, so that the backend sees an 'X' (Terminate) command arrive
and therefore cuts the connection from its end.
If the child just exits the pipe or TCP connection will remain open.

            regards, tom lane

pgsql-general by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: PostgreSQL 8.0.0 Officially Goes Beta
Next
From: Josué Maldonado
Date:
Subject: dump/restore from 7.4.3linux to 8beta1 win32