Installation issue

[pgstef]

Hi,

Even with PG installed from sources, the CREATE EXTENSION doesn't seem to find the required libraries.

Error example:

$ psql -d postgres -c "CREATE EXTENSION IF NOT EXISTS parquet_s3_fdw;"
ERROR:  could not load library "/usr/local/pgsql/lib/parquet_s3_fdw.so": libaws-cpp-sdk-core.so: cannot open shared object file: No such file or directory

$ sudo find / -name libaws-cpp-sdk-core.so
/usr/local/lib/libaws-cpp-sdk-core.so

I've installed AWS SDK for C++ using the following steps (on Ubuntu 22.04):

git clone --recurse-submodules https://github.com/aws/aws-sdk-cpp
mkdir sdk_build && cd sdk_build
cmake ../aws-sdk-cpp -DCMAKE_BUILD_TYPE=Debug -DCMAKE_PREFIX_PATH=/usr/local/ -DCMAKE_INSTALL_PREFIX=/usr/local/ -DBUILD_ONLY="s3"
make
sudo make install

And installed this extension using:

wget https://ftp.postgresql.org/pub/source/v16.1/postgresql-16.1.tar.gz
tar xzf postgresql-16.1.tar.gz
wget https://github.com/pgspider/parquet_s3_fdw/archive/refs/tags/v1.1.0.tar.gz
tar -xzf v1.1.0.tar.gz
mv parquet_s3_fdw-1.1.0 postgresql-16.1/contrib/parquet_s3_fdw
cd postgresql-16.1
./configure
make
sudo make install
cd contrib/parquet_s3_fdw
make
sudo make install

Could you help me spot what did I miss please?

Also, what would be your recommended way to integrate this library and build the extension against PG installed with the PGDG package?

Many thanks in advance for your feedback,
Kind Regards