Unsafe use of relative rpath on macOS 11.2 when creating extension

[smills2929]

Relevant system information:

• OS: macOS 11.2
• PostgreSQL version 12.5
• TimescaleDB version 2.0.1
• Installation method: source

Describe the bug After having built and installed Timescale from source I get an error when running 'CREATE EXTENSION timescaledb':

ERROR: could not load library "/Library/PostgreSQL/12/lib/postgresql/timescaledb-tsl-2.0.1.so": dlopen(/Library/PostgreSQL/12/lib/postgresql/timescaledb-tsl-2.0.1.so, 10): Library not loaded: libpq.5.dylib Referenced from: /Library/PostgreSQL/12/lib/postgresql/timescaledb-tsl-2.0.1.so Reason: unsafe use of relative rpath libpq.5.dylib in /Library/PostgreSQL/12/lib/postgresql/timescaledb-tsl-2.0.1.so with restricted binary SQL state: 58P01

To Reproduce Steps to reproduce the behavior:

1. Install Timescale from source on a macOS 11.2 machine
2. Run "CREATE EXTENSION timescaledb;"
3. Watch the failure

Expected behavior It doesn't error and properly creates the extension.

Actual behavior It throws the above error and fails to create extension.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context I used the EDB PostgreSQL 12.5 installer to install postgres.

The only other extension I have is PostGIS 2.5.

This is the command I used to bootstrap timescale. ./bootstrap -DOPENSSL_ROOT_DIR=/usr/local/opt/openssl -DOPENSSL_LIBRARIES=/usr/local/opt/openssl/lib -DREGRESS_CHECKS=OFF -DLINTER=OFF

[mfreed]

Mac OSX has significantly locked down their permissions model in recently OS versions. Do you see anything about granting permissions around this executable?

Or does this help at all? Esp. that you are installing from source:

https://travis-ci.community/t/unsafe-use-of-relative-rpath-with-restricted-binary/7308/2

[jiamo]

maybe related https://github.com/timescale/timescaledb/issues/4997