Error while using CREATE EXTENSION command

[IshaanAdarsh]

Running into the error while creating a C-based Postgres Extension

Code for the Extension is present in my Github repo

make command output:

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Werror=unguarded-availability-new -Wendif-labels -Wmissing-format-attribute -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-compound-token-split-by-macro -Wno-deprecated-non-prototype -O2  -I. -I./ -I/Users/spartacus/.pgenv/pgsql-15.0/include/server -I/Users/spartacus/.pgenv/pgsql-15.0/include/internal  -isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX13.3.sdk    -c -o pg_cext.o pg_cext.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Werror=unguarded-availability-new -Wendif-labels -Wmissing-format-attribute -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-compound-token-split-by-macro -Wno-deprecated-non-prototype -O2  pg_cext.o -L/Users/spartacus/.pgenv/pgsql-15.0/lib -isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX13.3.sdk   -Wl,-dead_strip_dylibs   -bundle -bundle_loader /Users/spartacus/.pgenv/pgsql-15.0/bin/postgres -o pg_cext.so

make install command output:

/opt/homebrew/bin/gmkdir -p '/Users/spartacus/.pgenv/pgsql-15.0/share/extension'
/opt/homebrew/bin/gmkdir -p '/Users/spartacus/.pgenv/pgsql-15.0/share/extension'
/opt/homebrew/bin/gmkdir -p '/Users/spartacus/.pgenv/pgsql-15.0/lib'
/opt/homebrew/bin/ginstall -c -m 644 .//pg_cext.control '/Users/spartacus/.pgenv/pgsql-15.0/share/extension/'
/opt/homebrew/bin/ginstall -c -m 644 .//pg_cext--1.0.0.sql  '/Users/spartacus/.pgenv/pgsql-15.0/share/extension/'
/opt/homebrew/bin/ginstall -c -m 755  pg_cext.so '/Users/spartacus/.pgenv/pgsql-15.0/lib/'

But for some reason while i am executing the CREATE EXTENSIONcommand, it is giving the error:

spartacus=# CREATE EXTENSION pg_cext;
ERROR:  could not load library "/Users/spartacus/Desktop/GSoC/CODE/pg_cext": dlopen(/Users/spartacus/Desktop/GSoC/CODE/pg_cext, 0x000A): tried: '/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (not a file), '/System/Volumes/Preboot/Cryptexes/OS/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (no such file), '/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (not a file)

But the extension files are present at this given location.

How do I tackle this issue?

[IshaanAdarsh]

StackOverflow Link: https://stackoverflow.com/questions/76692639/error-while-using-create-extension-command

[IshaanAdarsh]

Removed the previous question due to no positive response.

[IshaanAdarsh]

PostgreSQL Extension: "could not load library" error while creating C-based Extension

I am facing an issue while trying to create a C-based PostgreSQL extension. I have the extension code available in my GitHub repository, and I am trying to load it using the CREATE EXTENSION command in PostgreSQL. However, I am encountering the following error:

ERROR: could not load library "/Users/spartacus/Desktop/GSoC/CODE/pg_cext": dlopen(/Users/spartacus/Desktop/GSoC/CODE/pg_cext, 0x000A): tried: '/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (not a file), '/System/Volumes/Preboot/Cryptexes/OS/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (no such file), '/Users/spartacus/Desktop/GSoC/CODE/pg_cext' (not a file)

I have verified that the extension files are present at the given location, and the necessary permissions are also set. Despite this, the extension is not loading, and the error persists.

Steps Taken to Resolve the Issue:

1. I have checked the file permissions for the extension files, and they seem to be correct.

ls -l /Users/spartacus/Desktop/GSoC/CODE/pg_cext


total 80
-rw-r--r--@ 1 spartacus  staff    139 Jul 15 12:24 Makefile
-rw-r--r--@ 1 spartacus  staff    100 Jul 15 12:27 pg_cext--1.0.0.sql
-rw-r--r--@ 1 spartacus  staff    227 Jul 15 12:27 pg_cext.c
-rw-r--r--@ 1 spartacus  staff    157 Jul 15 11:56 pg_cext.control
-rw-r--r--  1 spartacus  staff    984 Jul 17 09:14 pg_cext.o
-rwxr-xr-x  1 spartacus  staff  16951 Jul 17 09:14 pg_cext.so

2. I have tried reloading PostgreSQL, but the error still occurs.
3. I have confirmed that the extension files exist at the specified location, but the error message suggests otherwise.

My Environment:

• PostgreSQL version: postgres (PostgreSQL) 15.0
• Operating System: MacOS [M1 chip]
• Extension Code

Can anyone help me troubleshoot and fix this issue? Thank you in advance for your assistance!

[IshaanAdarsh]

StackOverflow: https://stackoverflow.com/questions/76768743/postgresql-extension-could-not-load-library-error-while-creating-c-based-exte

[IshaanAdarsh]

Done, i am a stupid fuck.
its the control file issue: module_pathname = '$libdir/pg_cext'
i should have added this to this.