setup-cli
setup-cli copied to clipboard
gen_salt does not exist in github action
Bug report
- [x] I confirm this is a bug with Supabase, not with my own application.
- [x] I confirm I have searched the Docs, GitHub Discussions, and Discord.
Describe the bug
When using supabase/setup-cli with postgres 14, gen_salt does not exist.
To Reproduce
This workflow results in the following error:
Setting up initial schema...
Seeding globals from roles.sql...
Applying migration 20231011094125_remote_schema.sql...
Applying migration 20231011124214_add_create_new_profile_trigger.sql...
Applying migration 20231012051835_fix_db_lint.sql...
Applying migration 20231020114830_add_community_access_constraint.sql...
Applying migration 20231101212133_user_settings.sql...
Applying migration 20231206121703_update_communities_allow_pre_seat.sql...
Applying migration 20240211173256_draft_games.sql...
Applying migration 20240223203511_remote_schema.sql...
Applying migration 20240227071349_webcal.sql...
Applying migration 20240227211909_fix-json-parse-notifications.sql...
Seeding data from supabase/seed.sql...
Stopping containers...
failed to send batch: ERROR: function gen_salt(unknown) does not exist (SQLSTATE 42883)
Also noteworthy is that one of my migrations does include enabling pgcrypto:
CREATE EXTENSION IF NOT EXISTS "pgcrypto" WITH SCHEMA "extensions";
Expected behavior
gen_salt should exist when starting supabase db
System information
github runner is ubuntu-latest
Additional context
I had no issues with this in the past. It was only after returning from a few months away that this was found to have stopped working. I also asked about this on discord