Missing PG_MODULE_MAGIC error

[Abhishek Chanda <rony358@xxxxxxxxx>]

Hi all,

I am trying to test an extension that links to rocksdb. When I try to load it in postgres, it complains "missing magic block" while I do have PG_MODULE_MAGIC in my src. Here is a minimal repro

// pgtam.c

#include "postgres.h"
#include <assert.h>
#include "fmgr.h"
#include "access/tableam.h"
#include "access/heapam.h"
#include "nodes/execnodes.h"
#include "catalog/index.h"
#include "commands/vacuum.h"
#include "utils/builtins.h"
#include "executor/tuptable.h"

#include "rocksdb/c.h"

PG_MODULE_MAGIC;

// Makefile

MODULE_big = pgtam
EXTENSION = pgtam
DATA = "">
PG_CPPFLAGS += -L/usr/local/lib -g
SHLIB_LINK += -L/usr/local/lib -lrocksdb

PG_CONFIG = /usr/local/pgsql/bin/pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)

// extension build

╰─$ make clean && make && sudo make install
rm -f pgtam.dylib   libpgtam.a  libpgtam.pc
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 -g -ggdb -Og -g3 -fno-omit-frame-pointer  -fvisibility=hidden -bundle -o pgtam.dylib  -L/usr/local/pgsql/lib  -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX14.4.sdk   -Wl,-dead_strip_dylibs   -fvisibility=hidden -L/usr/local/lib -lrocksdb -bundle_loader /usr/local/pgsql/bin/postgres
/opt/homebrew/bin/gmkdir -p '/usr/local/pgsql/lib'
/opt/homebrew/bin/gmkdir -p '/usr/local/pgsql/share/extension'
/opt/homebrew/bin/gmkdir -p '/usr/local/pgsql/share/extension'
/opt/homebrew/bin/ginstall -c -m 755  pgtam.dylib '/usr/local/pgsql/lib/pgtam.dylib'
/opt/homebrew/bin/ginstall -c -m 644 .//pgtam.control '/usr/local/pgsql/share/extension/'
/opt/homebrew/bin/ginstall -c -m 644 .//pgtam--0.0.1.sql  '/usr/local/pgsql/share/extension/'

Postgres build: cloned and built at SHA 849172ff4883d44168f96f39d3fde96d0aa34c99

╰─$ /usr/local/pgsql/bin/pg_ctl -D test-db -l logfile restart
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started                                                                                                                                  
╭─~/src/postgres ‹849172ff48●›
╰─$ /usr/local/pgsql/bin/psql postgres
psql (17devel)
Type "help" for help.

postgres=# CREATE EXTENSION pgtam;
ERROR:  incompatible library "/usr/local/pgsql/lib/pgtam.dylib": missing magic block
HINT:  Extension libraries are required to use the PG_MODULE_MAGIC macro.

What am I missing?