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