g++ error (solved locally)

[houstonhaynes]

This is more of an install/documentation note - I've installed duckdb_fdw on a few different linux virts/VMs and this is the first time I remember seeing this issue...

Following the instructions in the readme I install the pre-reqs

postgresql-server-{version}-dev
(which is now postgresql-server-dev-{version})
gcc
make

And from that I encountered this error when running make USE_PGXS=1

make install USE_PGXS=1
g++ -Wall -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -std=c++11 -D_GLIBCXX_USE_CXX11_ABI=0 -fPIC -fvisibility=hidden -fvisibility-inlines-hidden -I. -I./ -I/usr/include/postgresql/16/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o sqlite3_api_wrapper.o sqlite3_api_wrapper.cpp
make: g++: No such file or directory
make: *** [: sqlite3_api_wrapper.o] Error 127
g++ -Wall -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -std=c++11 -D_GLIBCXX_USE_CXX11_ABI=0 -fPIC -fvisibility=hidden -fvisibility-inlines-hidden -I. -I./ -I/usr/include/postgresql/16/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o sqlite3_api_wrapper.o sqlite3_api_wrapper.cpp
make: g++: No such file or directory
make: *** [: sqlite3_api_wrapper.o] Error 127

So I ran apt install g++ and afterward the make commands proceeded without error.

In this case I was installing on a Debian LXC in Proxmox, which I imagine is pretty stripped down compared to the Ubuntu (24-04) I had used before. So as an FYI - it may be worth adding a note in the install instructions - either just adding g++ to the list of dependencies to install (where instances with it already on the machine will just move past it) or add a sidebar for users on Debian or other/slimmer Linux builds to also install g++.

Love this plugin! Thanks for all the work!