Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ya8Yu-0004Fi-5a for pgsql-interfaces@arkaria.postgresql.org; Mon, 23 Mar 2015 20:03:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ya8Yt-0000Au-Bk for pgsql-interfaces@arkaria.postgresql.org; Mon, 23 Mar 2015 20:02:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ya8Yr-0000Af-C6 for pgsql-interfaces@postgresql.org; Mon, 23 Mar 2015 20:02:57 +0000 Received: from zql.com ([206.222.31.58]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Ya8Ym-0002Nl-J8 for pgsql-interfaces@postgresql.org; Mon, 23 Mar 2015 20:02:56 +0000 Received: from localhost ([127.0.0.1]) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1Ya8Yh-0006bG-Vl; Mon, 23 Mar 2015 16:02:48 -0400 From: "Greg Sabino Mullane" To: pgsql-interfaces@postgresql.org Subject: Re: Problem when forking X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Content-type: text/plain; charset=UTF-8 Date: Mon, 23 Mar 2015 20:02:47 -0000 X-Mailer: JoyMail 3.1.0 Message-ID: <2ec30f86c6dae08c20fdf53aa3ce20f0@biglumber.com> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-interfaces Precedence: bulk Sender: pgsql-interfaces-owner@postgresql.org -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > I am seeing too many messages like "unexpected EOF on client connection". > I've made a reasearch and I know the reason: I have processes that fork and > don't close the connection causing those warnings. > > My questions is: is there a way to avoid that behavior beside of closing > the connection before forking? You can fork, you just have to make sure one side keeps talking to Postgres like normal, and the other should pretend Postgres is not there. It should also not do anything that would affect the first connection. In general, it is a really good rule to fork *then* connect. - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201503231601 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAlUQcUQACgkQvJuQZxSWSsh6eACdHvemvFLrV3VIZtECAOZB6gjX BjoAoKGOoKc2yKDAfi5M2siDMMMjazaC =kV9C -----END PGP SIGNATURE----- -- Sent via pgsql-interfaces mailing list (pgsql-interfaces@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces