ERROR: could not load library "/Library/PostgreSQL/lib/postgresql/llvmjit.so": dlopen(/Library/PostgreSQL/lib/postgresql/llvmjit.so, 10): Library not loaded: @loader_path/../..//opt/local/lib/libncurses.6.dylib Referenced from: /Library/PostgreSQL/lib/postgresql/llvmjit.so Reason: image not found
When the error occurs, I am running as a non-administrative user in macOS and as a non-administrative user in pgAdmin 4.
PostgreSQL was installed using the EDB Mac OS X installer for PostgreSQL version 12.3. The pgAdmin 4 version is 4.21.0. The Materialized View was created using the Create Materialized View contextual menu and the Materialized View was successfully saved. When the command to Refresh Materialized View was issued using the contextual menu, the error was generated about in about 0.25 sec. and the status code shown is: Failed (exit code: 1). PgAdmin 4 was used to refresh 36 other Materialized Views without error. This was the only case where an error occurred.
The files llvmjit.so and llvmjit_types.bc are both installed in /Library/PostgreSQL/lib/postgresql. File ownership for llvmjit.so is root:daemon and permissions are set to rwxr-xr-x.