Re: postgresql pg_curl bug? (solved)
- In reply to: ft : "postgresql pg_curl bug?"
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Wed, 13 Sep 2023 03:10:12 UTC
Hallo, the solution: today I have deinstall all dependencies and reinstall the package libidn2 from ports. On Sun, 2023-09-03 at 05:54 +0200, ft wrote: > Hello, > > I have install postgresql15 in jail. > I need the postgresql extension pg_curl. > > cd pg_curl-2.1.1/ > gmake install > cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after- > statement -Werror=vla -Werror=unguarded-availability-new -Wendif- > labels > -Wmissing-format-attribute -Wcast-function-type -Wformat-security - > fno- > strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno- > compound-token-split-by-macro -O2 -pipe -fstack-protector-strong - > fno- > strict-aliasing -fPIC -DPIC -I. -I./ - > I/usr/local/include/postgresql/server - > I/usr/local/include/postgresql/internal -I/usr/local/include - > I/usr/local/include -I/usr/local/include -c -o pg_curl.o pg_curl.c > cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after- > statement -Werror=vla -Werror=unguarded-availability-new -Wendif- > labels > -Wmissing-format-attribute -Wcast-function-type -Wformat-security - > fno- > strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno- > compound-token-split-by-macro -O2 -pipe -fstack-protector-strong - > fno- > strict-aliasing -fPIC -DPIC -shared -o pg_curl.so pg_curl.o - > L/usr/local/lib -L/usr/local/lib -lpthread -L/usr/local/lib - > fstack- > protector-strong -L/usr/local/lib -Wl,--as-needed -Wl,- > R'/usr/local/lib' -lcurl > /bin/mkdir -p '/usr/local/lib/postgresql' > /bin/mkdir -p '/usr/local/share/postgresql/extension' > /bin/mkdir -p '/usr/local/share/postgresql/extension' > /usr/bin/install -c -m 755 pg_curl.so > '/usr/local/lib/postgresql/pg_curl.so' > /usr/bin/install -c -m 644 .//pg_curl.control > '/usr/local/share/postgresql/extension/' > /usr/bin/install -c -m 644 .//pg_curl--1.0--2.0.sql .//pg_curl-- > 1.0.sql > .//pg_curl--2.0--2.1.sql .//pg_curl--2.0.sql .//pg_curl--2.1.sql > '/usr/local/share/postgresql/extension/' > > find /usr -name "*pg_curl*" > /usr/local/share/postgresql/extension/pg_curl--2.0.sql > /usr/local/share/postgresql/extension/pg_curl.control > /usr/local/share/postgresql/extension/pg_curl--2.1.sql > /usr/local/share/postgresql/extension/pg_curl--2.0--2.1.sql > /usr/local/share/postgresql/extension/pg_curl--1.0.sql > /usr/local/share/postgresql/extension/pg_curl--1.0--2.0.sql > > > In postgresql, the command: > create extension pg_curl; > get the errormessage: > > ftc=# create extension pg_curl; > FEHLER: konnte Bibliothek »/usr/local/lib/postgresql/pg_curl.so« > nicht > laden: /usr/local/lib/libidn2.so.0: Undefined symbol "strversc > mp@FBSD_1.7" > > libidn2 is installed: > > ls -l /usr/local/lib/libidn2* > root wheel 281986 Feb 9 2023 /usr/local/lib/libidn2.a > root wheel 16 Feb 9 2023 /usr/local/lib/libidn2.so -> > libidn2.so.0.3.8 > root wheel 16 Feb 9 2023 /usr/local/lib/libidn2.so.0 -> > libidn2.so.0.3.8 > root wheel 202256 Feb 9 2023 /usr/local/lib/libidn2.so.0.3.8 > > uname -a > FreeBSD ftc 13.2-RELEASE-p2 FreeBSD 13.2-RELEASE-p2 GENERIC amd64 > > Do you need more information? > What should I do? > > Franz > > > >