Error installing the Queues Integration
Report: "pgmq extension enablement fails with 'function pgmq.drop_queue(text) does not exist' error
during CREATE EXTENSION"
Reference: gdvdgqlbldxmpaehaesg (WT-Fin-Tech, us-east-2)
Request Postgres version check (needs 15.6.1.143+)
Reference: gdvdgqlbldxmpaehaesg (WT-Fin-Tech, us-east-2)
Request Postgres version check (needs 15.6.1.143+)
10 Replies
If you are hosted you need to upgrade your postgres version under infrastructure settings.
i just realized, i'm in postgres 17, and still getting that error , are you using Queues? did you install it successfully ? @garyaustin
You need to be on the latest pg 17 version. There was a fix about 2 weeks a go.
@garyaustin i just tried upgrading to that version and it failed
let me try again '
What failed? The upgrade or pgmq install?
the upgrade, i'm on 17.4.1.064
have to wait for 16 minutes
With the latest version:
And I got the error you see before that.
https://github.com/orgs/supabase/discussions/39764
got it, so I essentially have to successfully upgrade my project then try again, but even in the upgrate logs , its unclear why the upgrade failed
Doubt I'll be able to help with that.
You may need to contact support.
Usually it gives a list of things your need to resolve (if any) before hand.
I've not really had need to look at error logs for it.