supabase-postgres.git / summary / log / commit / refs

commit    04d24e83f304fcd9f4e0e1caf09b3a3e3ce1eeb4
Author:   Paul Cioanca <paul.cioanca@supabase.io>
Commit:   GitHub <noreply@github.com>
Date:     Sat Jul 20 10:17:52 2024 +0000

    fix: wrappers upgrade from 0.3.0 to 0.4.1 (#1062)


 ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
index d67d623d..b795c159 100755
--- a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
+++ b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
@@ -25,6 +25,13 @@ function cleanup {
     exit "$EXIT_CODE"
 }
 
+function execute_extension_upgrade_patches {
+    if [ -f "/var/lib/postgresql/extension/wrappers--0.3.1--0.4.1.sql" ] && [ ! -f "/usr/share/postgresql/15/extension/wrappers--0.3.0--0.4.1.sql" ]; then
+        cp /var/lib/postgresql/extension/wrappers--0.3.1--0.4.1.sql /var/lib/postgresql/extension/wrappers--0.3.0--0.4.1.sql
+        ln -s /var/lib/postgresql/extension/wrappers--0.3.0--0.4.1.sql /usr/share/postgresql/15/extension/wrappers--0.3.0--0.4.1.sql
+    fi
+}
+
 function execute_patches {
     # Patch pg_net grants
     PG_NET_ENABLED=$(run_sql -A -t -c "select count(*) > 0 from pg_extension where extname = 'pg_net';")
@@ -99,6 +106,8 @@ function complete_pg_upgrade {
         CI_start_postgres --new-bin
     fi
 
+    execute_extension_upgrade_patches || true
+
     echo "4. Running generated SQL files"
     retry 3 run_generated_sql
 


[parent: f79c4d17b7e8]