Unable to create DuckDB Extension is PostgresDB

[vivekmystrey]

Have created DuckDB Foreign Data Wrapper' with Postgres version 15 and DuckDB Version 1.3.2. While creating the Docker Image, the build initially failed, but after setting the symlink ln -s libduckdb.so libduckdb.1.3.2.so` it is successful.

But will creating duckdb_fdw, get following error:

could not load library "/usr/lib/postgresql/15/lib/duckdb_fdw.so": /usr/lib/postgresql/15/lib/duckdb_fdw.so: undefined symbol: _ZN6duckdb9Exception25ConstructMessageRecursiveERKSsRSt6vectorINS_20ExceptionFormatValueESaIS4_EE

Please advise, how to fix this issue?

[j4david]

Hello,
In my case I can fix the probelm changing the C++ ABI.

diff --git a/Makefile b/Makefile
index 6060e4d..81358c2 100644
--- a/Makefile
+++ b/Makefile
@@ -39,7 +39,7 @@ ifeq ($(detected_OS),Linux)
PG_CXXFLAGS = -std=c++11
detected_arch := $(shell uname -m)
ifeq ($(detected_arch),x86_64)

•    PG_CXXFLAGS = -std=c++11 -D_GLIBCXX_USE_CXX11_ABI=0
  

•    PG_CXXFLAGS = -std=c++11 -D_GLIBCXX_USE_CXX11_ABI=1
  

  endif
  endif

@@ -86,4 +86,4 @@ install: install-duckdb
uninstall-duckdb:
rm -f $(DESTDIR)$(PG_LIB)/libduckdb$(DLSUFFIX)