Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres DB crashing in OpenSSL 3.2 Version

Postgres DB crashing in OpenSSL 3.2 Version

From
kamal deen
Date:
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

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
Joe Tailleur
Date:
We fixed ours by upgrading Postgres to 15.10

Joe.

On Fri, Dec 13, 2024 at 9:28 AM kamal deen <kamaldeendba@gmail.com> 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

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
Tom Lane
Date:
kamal deen <kamaldeendba@gmail.com> writes:
>  We have noticed in our recent builds postgres (Rocky 9 OS , PG 15.2
> version) getting crash while trying to connect DB using certs.

You need PG 15.6 or later.

            regards, tom lane

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
kamal deen
Date:
Thank you Joe. Will try that.

SK

On Fri, Dec 13, 2024, 10:01 PM 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 AM kamal deen <kamaldeendba@gmail.com> 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

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
kamal deen
Date:
I have tested it with PG15.6 , it's working as expected.

Thanks for your response Joe 😊.

SK.

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

SK

On Fri, Dec 13, 2024, 10:01 PM 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 AM kamal deen <kamaldeendba@gmail.com> 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

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
kamal deen
Date:
Awesome 👌 

Thank you Holger Jakobs.

SK.


On Fri, Dec 13, 2024, 10:43 PM Holger Jakobs <holger@jakobs.com> wrote:
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 😊.

SK.

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

SK

On Fri, Dec 13, 2024, 10:01 PM 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 AM kamal deen <kamaldeendba@gmail.com> 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.


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


--

Holger Jakobs, Bergisch Gladbach

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
kamal deen
Date:
Hi All,

Do we have any fix for postgres version below 15.6? 
 
We do have some critical system still running in older than 15.6 (12,13,14) version due to some application compatibility.

Thanks in advance.

SK

On Fri, Dec 13, 2024, 9:57 PM kamal deen <kamaldeendba@gmail.com> 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

Re: Postgres DB crashing in OpenSSL 3.2 Version

From
Jerry Sievers
Date:
kamal deen <kamaldeendba@gmail.com> writes:

> Hi All,
>
> Do we have any fix for postgres version below 15.6?
>
> We do have some critical system still running in older than 15.6 (12,13,14) version due to some application
compatibility.

All but your v12 system are still supported.  v12 is EOL so don't expect
updates and v13 will be dropped late in 2025 as per the usual
end-of-lifing of older versions.

If whatever host platform you're on isn't offering you anything below
v15, then that's another matter that probably can be resolved by getting
from a different package repo.

If you're on some cloud hosting, then YMMV.  Contact the vendor.

HTH

>
> Thanks in advance.
>
> SK
>
> On Fri, Dec 13, 2024, 9:57 PM kamal deen <kamaldeendba@gmail.com> wrote:
>
>  Hi All,
>
>   We have noticed in our recent builds postgres (Rocky 9 OS , PG 15.2 version) getting crash while trying to connect
DBusing certs. 
>
>  Pls advise if we have any fix. ( without downgrade the OpenSSL).
>
>  Thanks
>  SK