Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tM9Rc-002CDd-K9 for pgsql-admin@arkaria.postgresql.org; Fri, 13 Dec 2024 17:27:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tM9RZ-009iqT-EQ for pgsql-admin@arkaria.postgresql.org; Fri, 13 Dec 2024 17:27:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tM9RY-009iq3-UW for pgsql-admin@lists.postgresql.org; Fri, 13 Dec 2024 17:27:14 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tM9RX-002ew2-Mv for pgsql-admin@lists.postgresql.org; Fri, 13 Dec 2024 17:27:13 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-2166f1e589cso22302985ad.3 for ; Fri, 13 Dec 2024 09:27:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734110831; x=1734715631; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=7idzF6Z0kejtrpJzv20xI3p/mO4SkMKWRSjd+QXgxys=; b=cUAIBK1JHaSAurrs69ZOB1DjwPFYSjOF1JFMHzoNJVfSWxBrB9OOPe9v23GY772ccg YUhz1YHLtVnnAjU7LXqpx4XXlBWF75apQ59H0lx6Nd8fe/xcupntVznFxa6IZwnItK5a UMP9UJWBeFDPrKIjHB7Yz/Y7a0Tz7EHqJHfDEasrc55APRl2b3NUdw4UOg/grYeDXyYm 0ALlEWB7cXWZaBp7F6uAZ05cu7asFUC9E5SL6tTW1KuFo2myqeZK/xDPO4TB+V8REJOX nGwKQl64XyodcZnABd3x6gFlYXPuwbRHMxEGnXtn56s8bbRmI127HogpSqN5YZfKG1EA zeMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734110831; x=1734715631; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=7idzF6Z0kejtrpJzv20xI3p/mO4SkMKWRSjd+QXgxys=; b=Zk6PmrzayFBm6b/8FypQnZ8GZQWFh7G2DT+uw9ozfqKOqlEGj/671nTpEyg27+2jXm up02jkw1pwyZVb9/lHGRhkRvpPrii8Q1xnwsxSFB01KUMp6LvCUmY+kQIRbgf2xCv+zD u2kovaxy80fgJ1VTiqf+To1v9PoxfaLBeaQikhPReD//Ec0pcxOnlSXg8qbVZR5LKvkr +UJw/51vw5t2Uw9/Weurcfe8JX0K3IQe0Qoji7cot87zdFUZrzMj2YpTaNMBwkKnVh21 DwnCBJO1bhY/Ty5ljZ/xk36IYMXlRNDjijRITWNb9Hg+PSmcUsbFKmUyLf94f7OQ+MRy CgNA== X-Gm-Message-State: AOJu0YxQ8FEfQahkHt1qHws0n8lBJ9n70OqArBWjMgal8gpQr6HKgz4H kez9IkUdHC0c94mGhVEvJDII7PosU+zhkpxxGtJNSshIQxZh0+GthWJdnG0VM6voEEzYVw2fXq2 1V4R2x+GPV3BBfSvtvpqbNJ/saoA= X-Gm-Gg: ASbGncsf5pZ72NRPxrbyyefYJtDicFC8u4iXH6WkfQ+hA+VCugZqiuSxWjEx6DAWF05 bXYqd+dtS2Ao/1/F0icrFT2bErpfZDUDa1o4rlPFdIhUUPjANsjPegPvA7jsGGoYL8UuDkChD X-Google-Smtp-Source: AGHT+IEK2w5uLiJL1fvyI1yP0PXizjB6qdL6vZ7RRWk5UdpFh5hyShp4WiPYULZr2Uh3bV1q2Y2MdVy9rfJm6gQjzeg= X-Received: by 2002:a17:903:41c5:b0:216:1cfa:2bda with SMTP id d9443c01a7336-21892ab824emr46909845ad.43.1734110830609; Fri, 13 Dec 2024 09:27:10 -0800 (PST) MIME-Version: 1.0 References: <776ea919-1f59-63e1-682e-008631df7eb8@jakobs.com> In-Reply-To: <776ea919-1f59-63e1-682e-008631df7eb8@jakobs.com> From: kamal deen Date: Fri, 13 Dec 2024 22:57:00 +0530 Message-ID: Subject: Re: Postgres DB crashing in OpenSSL 3.2 Version To: Holger Jakobs Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000000f516d06292a2445" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000f516d06292a2445 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Awesome =F0=9F=91=8C Thank you Holger Jakobs. SK. On Fri, Dec 13, 2024, 10:43=E2=80=AFPM Holger Jakobs wr= ote: > Am 13.12.24 um 18:06 schrieb kamal deen: > > I have tested it with PG15.6 , it's working as expected. > > Thanks for your response Joe =F0=9F=98=8A. > > SK. > > On Fri, Dec 13, 2024, 10:15=E2=80=AFPM kamal deen wrote: > >> Thank you Joe. Will try that. >> >> SK >> >> On Fri, Dec 13, 2024, 10:01=E2=80=AFPM Joe Tailleur >> wrote: >> >>> We fixed ours by upgrading Postgres to 15.10 >>> >>> Joe. >>> >>> On Fri, Dec 13, 2024 at 9:28=E2=80=AFAM kamal deen >>> wrote: >>> >>>> Hi All, >>>> >>>> We have noticed in our recent builds postgres (Rocky 9 OS , PG 15.2 >>>> version) getting crash while trying to connect DB using certs. >>>> >>>> Pls advise if we have any fix. ( without downgrade the OpenSSL). >>>> >>>> >>>> Thanks >>>> SK >>>> >>> > I cannot imagine any reason to go with any minor version but the latest. > Since jumping directly to the lastes minor is no problem, it's the way to > go. > > https://why-upgrade.depesz.com/show?from=3D15.6&to=3D15.10&keywords=3D > > Upgrading from 15.6 to 15.10 gives you 9.6 months worth of fixes (155 of > them) > > -- > > Holger Jakobs, Bergisch Gladbach > --0000000000000f516d06292a2445 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Awesome =F0=9F=91=8C=C2=A0

Thank you Holger Jakobs.

SK.


On Fri, Dec 13, 2024, 10:= 43=E2=80=AFPM Holger Jakobs <holger= @jakobs.com> wrote:
=20 =20 =20
Am 13.12.24 um 18:06 schrieb kamal deen:
=20
I have tested it with PG15.6 , it's working as expected.

Thanks for your response Joe =F0=9F=98=8A.

SK.

On Fri, Dec 13, 2024, 10:15= =E2=80=AFPM kamal deen <kamaldeendba@gmail.com> wrote:
Thank you Joe. Will try that.

SK

On Fri, Dec 13, 2024, 10:01=E2=80=AFPM Joe Tailleur <joe.tailleur= @gmail.com> wrote:
We fixed ours by upgrading Postgres to 15.10

Joe.

On Fri, Dec 13, 2024 at 9:28=E2=80=AFAM kamal deen <kamaldeendba@g= mail.com> wrote:
Hi All,

=C2=A0We have noticed in our recent builds postgres (Rocky 9 OS , PG 15.2 version) getting crash while trying to connect DB using certs.

Pls advise if we have any fix. ( without downgrade the OpenSSL).


Thanks=C2=A0
SK

I cannot imagine any reason to go with any minor version but the latest. Since jumping directly to the lastes minor is no problem, it's the way to go.

https://why-= upgrade.depesz.com/show?from=3D15.6&to=3D15.10&keywords=3D

Upgrading from 15.6 to 15.10 gives you 9.6 months worth of fixes (155 of them)


--

Holger Jakobs, Bergisch Gladbach

--0000000000000f516d06292a2445--