Re: pg_citus extension error

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?

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

```
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