I assumeed this is used like this
But I'm getting
ERROR: could not access file "MODULE_PATHNAME": No such file or directory
Reading the posts in the comments on the blog I can see it's used like this,
I think you are right about _PG_fini, but it is still there in the code. But _PG_init called in case of CREATE EXTENSION too.
sudo make install;
psql -c'create extension log;''