SupabaseS
Supabase•12mo ago
jumski

PGMQ versioning in Supabase - question

Tembo recently released PGMQ 1.5.0, which adds message headers
  • a super useful feature for metadata like retry info, task handler names, and error details (similar to HTTP headers). However, the PGMQ version shipped with Supabase is still at 1.4.4 (two versions behind). This also means we’re missing the 1.4.5 fix for high CPU usage in read_with_poll.
tried upgrading locally using the Supabase CLI (v2.1.1) but hit this error:

ERROR:  22023: extension "pgmq" has no installation script nor update path for version "1.5.0"


\dx pgmq confirms the current version is 1.4.4.

Questions:
  1. Is the PGMQ version hardcoded in Supabase, meaning we have to wait for Supabase to upgrade it?
  2. If not, how can we upgrade it manually in a Supabase-managed environment?
  3. If it is locked, is there any way to apply the SQL changes manually for a partial upgrade (assuming only SQL changes are involved)?
For reference, here’s the PR introducing headers: https://github.com/tembo-io/pgmq/pull/338

Any guidance would be greatly appreciated!
GitHub
Implement message headers by v0idpwn · Pull Request #338 · tembo-io...
Closes #203
Needed for #294
Was this page helpful?