segmentation fault with node 18 and ssl_mode require

[wzrdtales]

currently there is a segmentation fault together with node 18 and SSL cert authorization

[remotezygote]

This has been an issue for quite a long time. Is there any hope for a fix?

[charmander]

Your Node and libpq need to be linked against ABI-compatible OpenSSLs (compare openssl -version to node -p process.versions.openssl, usually), i.e. both 1.1.* or both 3.*.*.

[graycraft]

Same issue here, we are using latest stable pg-native 3.5.2 with ABI-compatible OpenSSL 3:

$ openssl version
  OpenSSL 3.0.15 3 Sep 2024 (Library: OpenSSL 3.0.15 3 Sep 2024)

$ node -p process.versions
  {
    node: '20.19.4',
    acorn: '8.14.0',
    ada: '2.9.2',
    ares: '1.34.5',
    brotli: '1.1.0',
    cjs_module_lexer: '1.4.1',
    cldr: '47.0',
    icu: '77.1',
    llhttp: '9.2.1',
    modules: '115',
    napi: '9',
    nghttp2: '1.61.0',
    nghttp3: '0.7.0',
    ngtcp2: '1.1.0',
    openssl: '3.0.15+quic',
    simdutf: '6.4.2',
    tz: '2025b',
    undici: '6.21.2',
    unicode: '16.0',
    uv: '1.46.0',
    uvwasi: '0.0.21',
    v8: '11.3.244.8-node.29',
    zlib: '1.3.0.1-motley-82a5fec'
  }

Tracing error with segfault-handler reveals that the problem is in build/Release/addon.node:

$ node app.js
  PID 223657 received SIGSEGV for address: 0x1000001b7
  /home/dp/Projects/adamant/node_modules/segfault-handler/build/Release/segfault-handler.node(+0x2e65)[0x7f55c6cf8e65]
  /lib/x86_64-linux-gnu/libpthread.so.0(+0x13140)[0x7f55c69b4140]
  /lib/x86_64-linux-gnu/libssl.so.1.1(SSL_get_peer_certificate+0x13)[0x7f55c450f2d3]
  /lib/x86_64-linux-gnu/libpq.so.5(+0x297e7)[0x7f55c45937e7]
  /lib/x86_64-linux-gnu/libpq.so.5(PQconnectPoll+0x919)[0x7f55c457ea69]
  /lib/x86_64-linux-gnu/libpq.so.5(+0x16995)[0x7f55c4580995]
  /lib/x86_64-linux-gnu/libpq.so.5(PQconnectdb+0x38)[0x7f55c4580b58]
  /home/dp/Projects/adamant/node_modules/libpq/build/Release/addon.node(+0x8a84)[0x7f55c45d2a84]
  /home/dp/Projects/adamant/node_modules/libpq/build/Release/addon.node(+0xa783)[0x7f55c45d4783]
  node[0x18c3140]
  /lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7)[0x7f55c69a8ea7]
  /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f55c68c8adf]
  Segmentation fault