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

commit    413a82d9bc70e5b80e2cf3b38f0f28198a3fce17
Author:   samrose <samuel@supabase.io>
Commit:   GitHub <noreply@github.com>
Date:     Tue May 20 16:47:56 2025 +0000

    fix: continue to use previous way to read old pg version in upgrade script (#1601)


 ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh | 2 +-
 ansible/vars.yml                                               | 6 +++---
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh b/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh
index 85b025be..18850883 100755
--- a/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh
+++ b/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh
@@ -41,7 +41,7 @@ LOG_FILE="/var/log/pg-upgrade-initiate.log"
 
 POST_UPGRADE_EXTENSION_SCRIPT="/tmp/pg_upgrade/pg_upgrade_extensions.sql"
 POST_UPGRADE_POSTGRES_PERMS_SCRIPT="/tmp/pg_upgrade/pg_upgrade_postgres_perms.sql"
-OLD_PGVERSION=$(pg_config --version | sed 's/PostgreSQL \([0-9]*\.[0-9]*\).*/\1/')
+OLD_PGVERSION=$(run_sql -A -t -c "SHOW server_version;")
 
 # Skip locale settings if both versions are PostgreSQL 17+
 if ! [[ "$OLD_PGVERSION" =~ ^17.* && "$PGVERSION" =~ ^17.* ]]; then
diff --git a/ansible/vars.yml b/ansible/vars.yml
index b935fd7a..87233533 100644
--- a/ansible/vars.yml
+++ b/ansible/vars.yml
@@ -9,9 +9,9 @@ postgres_major:
 
 # Full version strings for each major version
 postgres_release:
-  postgresorioledb-17: "17.0.1.084-orioledb"
-  postgres17: "17.4.1.034"
-  postgres15: "15.8.1.091"
+  postgresorioledb-17: "17.0.1.085-orioledb"
+  postgres17: "17.4.1.035"
+  postgres15: "15.8.1.092"
 
 # Non Postgres Extensions
 pgbouncer_release: "1.19.0"


[parent: 0fddd4725ca7]