pgxn install pg_bm25 => ERROR: no Makefile found in the extension root

[stephane-klein]

Hi @philippemnoel,

I just posted this comment and right after I saw this Pull Request you authored.

I'm trying to install the extension pg_bm25 (pg_search) with pgxn in the docker image postgres:16 :

$ docker run --rm -it postgres:16 bash
root@631f852e2bfa:/# apt-get update -y; apt-get install -y pgxnclient build-essential
...
root@631f852e2bfa:/# pgxn install pg_bm25
INFO: best version: pg_bm25 9.9.9
INFO: saving /tmp/tmpykdtc3pi/pg_bm25-9.9.9.zip
INFO: unpacking: /tmp/tmpykdtc3pi/pg_bm25-9.9.9.zip
INFO: building extension
ERROR: no Makefile found in the extension root

Do you have any idea where my mistake might have come from? Did I forget to install a package?

Best regards,
Stéphane

[stephane-klein]

I think I may have found my mistake.

Should I not use pgxn install but should I use pgxn download :

root@28769237c982:~# pgxn download pg_bm25
INFO: best version: pg_bm25 9.9.9
INFO: saving /root/pg_bm25-9.9.9.zip

@philippemnoel Can you confirm my hypothesis?

[philippemnoel]

See below for my complete answer

[stephane-klein]

In the end, I ended up using the following method: https://github.com/stephane-klein/pg_search_docker/blob/master/Dockerfile

[philippemnoel]

This works great :)

[philippemnoel]

Hi @stephane-klein. I saw your comment, but somehow missed the discussion thread here, I apologize.

You did nothing wrong with pgxn, I did. Back when I was testing pgxn deployment, I made the (silly) mistake of publishing a high dummy version. pgxn does not support deleting releases, which I was not aware of, and so it is stuck on an old version. I've discussed it with @theory, the maintainer, who I believe is going to be adding this feature. We've since renamed pg_bm25 to pg_search, which I presume I could release to pgxn.

All this to say, in the meantime it is not possible to install ParadeDB pg_search via pgxn because we don't publish to it yet. You can find our latest prebuilt binaries in our GitHub Releases: https://github.com/paradedb/paradedb/releases/tag/v0.7.6. I see you've already found them, and it is the preferred way to install our extensions for now. Eventually we'll publish to APT and pgxn and a few others, but we haven't gotten around to it yet.

I apologize for the inconvenience