Failed to enable PGMQ (Queue Integration) .drop_queue(text) does not exist
I go menu > integrations > explore all > queues > enable pgmq
Expected: PGMQ is enabled.
Actual: Error toast: Failed to enable pgmq: function pgmq.drop_queue(text) does not exist
Omarchy 3.1.1
Chromium 141.0.7
2 Replies
You need to upgrade to the latest Postgres version in the infrastructure tab.
https://discord.com/channels/839993398554656828/1431347624082149386
Yes thank you I found https://github.com/orgs/supabase/discussions/39764 and came back to mark solved.
Project Settings > Infrastructure > Update Database > Let update run > Integrations > Install pgmq
GitHub
Cannot install pgmq extension — installer fails with missing func...
Hello Supabase Support team, I'm unable to install the pgmq extension in my project. Attempts to create the extension fail with the same error referencing a missing function pgmq.drop_queue(tex...