Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p27d9-0004eS-Kf for pgsql-general@arkaria.postgresql.org; Mon, 05 Dec 2022 09:19:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p27d8-0005ml-Hv for pgsql-general@arkaria.postgresql.org; Mon, 05 Dec 2022 09:19:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p21RA-00040r-Du for pgsql-general@lists.postgresql.org; Mon, 05 Dec 2022 02:42:32 +0000 Received: from sonic310-22.consmr.mail.gq1.yahoo.com ([98.137.69.148]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p21R7-0005k7-GK for pgsql-general@postgresql.org; Mon, 05 Dec 2022 02:42:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670208146; bh=5Vi/++nTu2hi5mFctow/k6hjgVLxpQkEcwi791MrhCo=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=OkCm1KdaW09pH5pPgdUH+hcPoIgRoozgu5VggV2SFmARiRBewOGVrth4J8P65OmN8heIooJs9jiwn+BCsjeJl2Pg4nRoyGQ5Tix384Is5/8WEQHS2XvlAXh1U84/FsPl+EAi15jAHasT13VhcKOUCWEcFKgfFTgH+t49wBxiO5qT8N8ACBDCj83xTiC+Sb8hv5AGA70WY1qUDiOaHIHUeXZtu8A5ITXFXHYaunR07k8ily+IyT4qbe+2GE0+bIJeNsM0HnEqCiDPyFEa8X28qiEdzvjFsMBZq+R6IVH7/I4jKFQi/abTe6pT6nlXFFlbkzZdd75NOPgw4AP/JvMjpg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1670208146; bh=VnMZig/ft0Hv2SIGdWoveGoYBTaeSWnD6f8+jelg3iw=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ptrlvchwT6QZa/BrBHEvfmgP81l03XrZ3X4wb4eO5Q2fERj7csBAmtV9UG49Mme9gOOGdjSRJD2QzmUV7guzhfkIX8FqQpGdpwqfWrZELj8uQouFpIe3YV4xQ3yjxtVlb7V1p82xgBW19G1lzRnqEiykLSoNhiD6LlysYjCRLpfpZqU8ZAN48970keKjej0P9Oyg0U6DVR2uWmFUucOI2A2h40Ia8icFJvTI1WnDeWhBoSI741F6eBklki1jSrSaDHO9JtEcuTC5LAKniKTDa+dyPYckhqblZDmejf5ZTL1fcUWFLuvm6JOrEdno4oAhtEE8XY231nn+7V4cL9Q4+g== X-YMail-OSG: CardvBMVM1kQlV1jWy0T9EAHCCTZXCn8Fg7Jh6zcA8JCY4UWxZuYmKfL5XT5bft 2.gpMBSAn2bxlGYFyA3436RSCwbR00OBSdlnsSs49LMK1mTbXijVxpcOKXUzPW94.LfRcI_a5r4M Qx3t_3Ux.HfFXiLni23L0uQkVyH4Dx5t9hqQHxgmVWAUgo8WfGz5tRg6DH0S8q.hiyHtTuOQnjMS lKosSvQqEFK0BqjrLmTsotKWeOYwrMD8rKQ9_7NkH73YGsr.2rnwMbxgAShB0i3639jHSE5KI.9W bSzmpR5xIltJKx6ynwxxGI8vzeJjAX9L7al1NB1Nrt1NGe5cufYl.PiFyao9C644tyRJDHj04Dxn K8Ob6gBabkPrh8geyigfGmNMHdSHDNsOvHXBuUQaV4DZIYYx6ioez31rhbPVz7PI_H6YO70BffVx sIeMJOfVz1K69Dzsxe..WWKdatdH0ve0tO5a4UM7ctwCHpS2aQ11BYuosyHHV.LqLingnBaEEzqO EF7GegV7GxxRmSzQCbtWhUSSJ48SdZnqCL5FRBKXe12McySK9cAlQa_gzTqr_avdo4adhlIDE7TQ Dnl97u1AY06v3yw75KJcPS1pgKNtGLcyJ8TBF7UZlP1viOpIlADujCtS9xKAiKyjr0SM9gxPV_zK B6ImhLHgJ3CU.ReKydEgrF83Ge6oy0hGqlco_5cb8IVfnr6atzW3b5GhRv9Q1H5cdBhiR4sg_n4o 460UFQuLvAVrbsEXy0xjHjy3srvFnxSHpF.wbhY5oH_0UxCcfRLS1TAtnJ9a6DiJn0PQH9erySHf L9.BUJL3TCn6vyHlihyLRu4nvL0kINgbSBIpqXkbEB.PLj1j1JNi43cUUMndknr393vYeeXXbyO1 iB4LwL31hbN8P9sKEQK6YPILPLP3ysj58biJmPw63.wC_3T9OoTWdSpNO5n0aDCkMVcWq4lkGHP6 pNPZHVBpTG8UWS0DCC32mgPbrOyOZW3jb2BzXl0gH8QnD5_MNjaLAahGMiEnz7RS9Qp2t.9pmu81 JXNJaSWqiePiHTbO_QYJHE..ylDtpaCaW7rPkzOJJH3.lRWLk4Kc.rFOKbhkEu22bDFQPJcufNpr ripyVtecYGlXe2qnDue7VjROsr6e0aV5_0xpkc3Lf2vIjYKdRP8APKKIbR5UUIh56xpDFGCUzQIU 6YOIEFdzPprm89n7hVl8Zq.92fnvwvflFyFDWx2Df.0NMb9QsD94l2NJWh75xqJyh3G6Pt8DMOTB eJ9EzWPnaAtXYdAvPXOuC6NpyITzI4NYaquuLXdlUK8M.H3UD6Cw0TBblzivZXrGLSIVXebOq5C_ vQaGyq610ugJ208OIVHUCYVYhA9.qKn5CCUY02vVgPcrYbCM3Spmvrbbx2hvO4BcQCtoJc.iBrX1 dt3DXgMiqyYnFbebNR0aPMY6RpAeeBKYkqVWD3jBlzRgAo0m4u2RuvsYXQqxLteHtEIQ2E1CasHq hUM57oVcJh33o_yB7Wa84NMN87bKBJi3PimjUN6K5.tcsXwgly886mPNtJ6AF0dLiyk0knqO4gR9 3Qnk5ZnYsn8EJD96vgEFGoRZYkOY48YeCGc9GiXPiiWbX0yCXwMhK2cOwh8TwMsc0k.imrZ9b1Vi iETMUfj40Yx.p57gHYqr4kNDOBy4_cECvVzCxpaYWk4l8Kvl9nQjB1QoirCCSwfbwBi2FcJhBQKW dQMcYVTeZ.chyUrI4_DlAKoCIboVF0ZZoaT6tVPlDJ4eCOFBVyGLGGLSZA2KFP0HRj61SMFvj7CB fjJ1V79M4Nsg.YOdoUCSu7VN2wCQA.gqtQg968l.pLbEAZxsk4YjbfdcZoXT_ZU2IVTAyEP8uRQD w_lCZMxAqbnYOTQYruCswbhi4dZeDfmzWvkqQnIA.M.2.cEoDQNMgNCRcjkHS_zzGIzv6nJshfOV MF06IW.jrrLzhbIoH0N6QEWiXdhHUltaGTmSP7erYHjIkR9OsyKcSnqcqdjTKw3zlxIHMnQTlbiE dl3v0PZMUEDBBaFYrdUVjN2DGg5SoVsbwqW5oGm1nGs5T.o290t6zcV6bVbVtBEKTAGRPVunb8s5 guhbxxdvoS1cUO9EM.KPvVm54AJ9XsSufqdcBXQpctDYoYJZwEZK6cDQgIZec6i8.Fl0qIZnC2ki Y6U_.iW496ILmn1BfPJHVf9FKMMsnFtQqBrwNvUhJ4s0DxgioyH_.6E1McwBta5JcRqq40ce7jor Jvk95FnxOJB39YKpGjd6.4F99V.8sKq78kyyLnQA- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.gq1.yahoo.com with HTTP; Mon, 5 Dec 2022 02:42:26 +0000 Date: Mon, 5 Dec 2022 02:42:20 +0000 (UTC) From: Ludwig Isaac Lim To: "pgsql-general@postgresql.org" Message-ID: <893661785.901171.1670208140915@mail.yahoo.com> In-Reply-To: <2242530.1670077780@sss.pgh.pa.us> References: <1649936435.214554.1669982358413.ref@mail.yahoo.com> <1649936435.214554.1669982358413@mail.yahoo.com> <2242530.1670077780@sss.pgh.pa.us> Subject: Re: print in plpython not appearing in logs MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Mailer: WebService/1.1.20926 YMailNorrin Content-Length: 1041 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Tom: >> I'm having problems wherein my print() statements inside my plpython sto= red proc are not appearing in postgresql log. I tried setting the file=3Dsy= s.stderr > Hmm.=C2=A0 I can tell you that with "logging_collector =3D on", I would o= nly expect the logs to capture stderr output, not stdout.=C2=A0 So it makes > sense to me that plain "print" would disappear into the bit bucket. But i= f you specify stderr output, it ought to work.=C2=A0 I don't know > enough Python to know why it's not working, but it seems to me this is pr= imarily a Python question not a Postgres question.=C2=A0 Maybe you need > an explicit fflush-equivalent step?=C2=A0 Dunno. >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 regards, tom lane As usual, thank you for pointing out where problem lies. I made it work by adding flush=3DTrue flag to the print() statement. print("oink oink", file=3Dsys.stderr, flush=3DTrue) I was under the wrong impression that output to stderr are automatically fl= ushed. Thank you once again. Regards, Ludwig