Re: pg_citus extension error

[Matthew Seaman]

On 16/06/2023 07:21, Matthew Seaman wrote:

On 16/06/2023 05:45, ft wrote:

A postgresql database v14 is running in a jail.
I installed pg_citus with portupgrade: no error messages

I get an error,
(1). when I create extension citus; or
(2). when I change shared_preload_libraries and restart the database

(1)
errormessage:
SQL Error [58P01]: ERROR: could not load library
"/usr/local/lib/postgresql/citus.so": /usr/local/lib/libcurl.so.4:
Undefined symbol
"nghttp2_option_set_no_rfc9113_leading_and_trailing_ws_validation"

Thank you very much for the report.  The symbol you mention only appears in the curl sources -- there's no reference from pg_citus.  So I feel this may be more a problem in curl than to do with pg_citus. Can I as what version of curl you have installed, and what options you used to build that port?

```
pkg:~...ports/databases/pg_citus:% ldd /usr/local/lib/libcurl.so.4.*
/usr/local/lib/libcurl.so.4.8.0:
        libnghttp2.so.14 => /usr/local/lib/libnghttp2.so.14 (0x26a93aa9f000)
        libidn2.so.0 => /usr/local/lib/libidn2.so.0 (0x26a93a4f8000)
        libssl.so.11 => /usr/local/lib/libssl.so.11 (0x26a93b050000)
        libcrypto.so.11 => /usr/local/lib/libcrypto.so.11 (0x26a93b9e7000)
        libzstd.so.1 => /usr/local/lib/libzstd.so.1 (0x26a93c739000)
        libz.so.6 => /lib/libz.so.6 (0x26a93c9d1000)
        libthr.so.3 => /lib/libthr.so.3 (0x26a93d655000)
        libc.so.7 => /lib/libc.so.7 (0x26a9362f3000)
        libunistring.so.5 => /usr/local/lib/libunistring.so.5 (0x26a93e223000)
```

        Cheers,

        Matthew

Also, what's the output from `ldd /usr/local/lib/libcurl.so.4.*` ? o should be seeing something like this:

OpenPGP_signature
Description: OpenPGP digital signature