Issue with pgmq Extension Installation – Request for Assistance

[hotkaybee]

Discussed in https://github.com/orgs/supabase/discussions/30091

^{Originally posted by hotkaybee October 25, 2024}
I’ve encountered an issue while trying to add the pgmq extension via the dashboard. Unfortunately, it’s not listed among the available extensions. As a workaround, I attempted to install it using SQL with the following command:
CREATE EXTENSION pgmq;
However, this approach also failed, returning the following error:

ERROR: 0A000: extension "pgmq" is not available  
DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/pgmq.control": No such file or directory.

I’ve spent a considerable amount of time troubleshooting, referencing the documentation, and exploring possible solutions, but without success. The fact that pgmq is mentioned in the documentation yet unavailable is quite frustrating.
Could you please address this issue as soon as possible or provide an alternative solution? Your prompt assistance would be greatly appreciated.

[frissonlabs]

Have you tried following the guide here?

https://database.dev/plpgsql/pgmq

[samrose]

Hi there. Thank you for reaching out to us for assistance. pgmq has been packaged and documented, and tested, but is still in the process of being rolled out for general usage. Thus it is not yet available for activation in instances. Once it's announced officially, then you would be able to use it in all of the documented ways. We apologize for the frustration you've experienced. Please hang in there and watch for announcements on the official release of this, and then you'll be up and running using it.