supabase-postgres.git / summary / log / commit / refs
commit 3642def34638a0769be89fffa82d44cdbfa84eb2
Author: samrose <samuel@supabase.io>
Commit: GitHub <noreply@github.com>
Date: Thu Mar 06 10:01:12 2025 +0000
chore: deprecate pg_backtrace (#1468)
* deprecate pg_backtrace
* handle in upgrade scripts
* bump version for release
ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh | 2 ++
ansible/vars.yml | 4 ++--
flake.nix | 1 -
nix/tests/expected/z_15_ext_interface.out | 6 ++----
nix/tests/expected/z_17_ext_interface.out | 6 ++----
nix/tests/postgresql.conf.in | 2 +-
nix/tests/prime.sql | 1 -
7 files changed, 9 insertions(+), 13 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 4e11f2d5..82ecb35b 100755
--- a/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh
+++ b/ansible/files/admin_api_scripts/pg_upgrade_scripts/initiate.sh
@@ -12,6 +12,7 @@
EXTENSIONS_TO_DISABLE=(
"pg_graphql"
"pg_stat_monitor"
+ "pg_backtrace"
)
PG14_EXTENSIONS_TO_DISABLE=(
@@ -217,6 +218,7 @@ function initiate_upgrade {
SHARED_PRELOAD_LIBRARIES=$(echo "$SHARED_PRELOAD_LIBRARIES" | sed "s/pg_net//" | xargs)
SHARED_PRELOAD_LIBRARIES=$(echo "$SHARED_PRELOAD_LIBRARIES" | sed "s/check_role_membership//" | xargs)
SHARED_PRELOAD_LIBRARIES=$(echo "$SHARED_PRELOAD_LIBRARIES" | sed "s/safeupdate//" | xargs)
+ SHARED_PRELOAD_LIBRARIES=$(echo "$SHARED_PRELOAD_LIBRARIES" | sed "s/pg_backtrace//" | xargs)
# Exclude empty-string entries, as well as leading/trailing commas and spaces resulting from the above lib exclusions
# i.e. " , pg_stat_statements, , pgsodium, " -> "pg_stat_statements, pgsodium"
diff --git a/ansible/vars.yml b/ansible/vars.yml
index ab9d94b4..79469371 100644
--- a/ansible/vars.yml
+++ b/ansible/vars.yml
@@ -8,8 +8,8 @@ postgres_major:
# Full version strings for each major version
postgres_release:
- postgresorioledb-17: "17.0.1.041-orioledb"
- postgres15: "15.8.1.047"
+ postgresorioledb-17: "17.0.1.042-orioledb"
+ postgres15: "15.8.1.048"
# Non Postgres Extensions
pgbouncer_release: "1.19.0"
diff --git a/flake.nix b/flake.nix
index 9ce842d3..4986ccb5 100644
--- a/flake.nix
+++ b/flake.nix
@@ -125,7 +125,6 @@
./nix/ext/postgis.nix
./nix/ext/pgrouting.nix
./nix/ext/pgtap.nix
- ./nix/ext/pg_backtrace.nix
./nix/ext/pg_cron.nix
./nix/ext/pgsql-http.nix
./nix/ext/pg_plan_filter.nix
diff --git a/nix/tests/expected/z_15_ext_interface.out b/nix/tests/expected/z_15_ext_interface.out
index 9914fa3b..9cc14323 100644
--- a/nix/tests/expected/z_15_ext_interface.out
+++ b/nix/tests/expected/z_15_ext_interface.out
@@ -77,7 +77,6 @@ order by
moddatetime | t
old_snapshot | t
pageinspect | t
- pg_backtrace | t
pg_buffercache | t
pg_freespacemap | t
pg_graphql | f
@@ -129,7 +128,7 @@ order by
vector | t
wrappers | f
xml2 | f
-(81 rows)
+(80 rows)
/*
@@ -1122,7 +1121,6 @@ order by
pageinspect | public | page_header | page bytea, OUT lsn pg_lsn, OUT checksum smallint, OUT flags smallint, OUT lower integer, OUT upper integer, OUT special integer, OUT pagesize integer, OUT version smallint, OUT prune_xid xid | record
pageinspect | public | tuple_data_split | rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text | bytea[]
pageinspect | public | tuple_data_split | rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text, do_detoast boolean | bytea[]
- pg_backtrace | public | pg_backtrace_init | | void
pg_buffercache | public | pg_buffercache_pages | | SETOF record
pg_freespacemap | public | pg_freespace | rel regclass, OUT blkno bigint, OUT avail smallint | SETOF record
pg_freespacemap | public | pg_freespace | regclass, bigint | smallint
@@ -5226,7 +5224,7 @@ order by
xml2 | public | xpath_table | text, text, text, text, text | SETOF record
xml2 | public | xslt_process | text, text | text
xml2 | public | xslt_process | text, text, text | text
-(5055 rows)
+(5054 rows)
/*
diff --git a/nix/tests/expected/z_17_ext_interface.out b/nix/tests/expected/z_17_ext_interface.out
index 45090f6e..0380ccd8 100644
--- a/nix/tests/expected/z_17_ext_interface.out
+++ b/nix/tests/expected/z_17_ext_interface.out
@@ -70,7 +70,6 @@ order by
moddatetime | t
orioledb | t
pageinspect | t
- pg_backtrace | t
pg_buffercache | t
pg_freespacemap | t
pg_graphql | f
@@ -117,7 +116,7 @@ order by
vector | t
wrappers | f
xml2 | f
-(75 rows)
+(74 rows)
/*
@@ -1142,7 +1141,6 @@ order by
pageinspect | public | page_header | page bytea, OUT lsn pg_lsn, OUT checksum smallint, OUT flags smallint, OUT lower integer, OUT upper integer, OUT special integer, OUT pagesize integer, OUT version smallint, OUT prune_xid xid | record
pageinspect | public | tuple_data_split | rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text | bytea[]
pageinspect | public | tuple_data_split | rel_oid oid, t_data bytea, t_infomask integer, t_infomask2 integer, t_bits text, do_detoast boolean | bytea[]
- pg_backtrace | public | pg_backtrace_init | | void
pg_buffercache | public | pg_buffercache_evict | integer | boolean
pg_buffercache | public | pg_buffercache_pages | | SETOF record
pg_freespacemap | public | pg_freespace | regclass, bigint | smallint
@@ -4906,7 +4904,7 @@ order by
xml2 | public | xpath_table | text, text, text, text, text | SETOF record
xml2 | public | xslt_process | text, text | text
xml2 | public | xslt_process | text, text, text | text
-(4747 rows)
+(4746 rows)
/*
diff --git a/nix/tests/postgresql.conf.in b/nix/tests/postgresql.conf.in
index ef860afc..ba1df515 100644
--- a/nix/tests/postgresql.conf.in
+++ b/nix/tests/postgresql.conf.in
@@ -718,7 +718,7 @@ default_text_search_config = 'pg_catalog.english'
#local_preload_libraries = ''
#session_preload_libraries = ''
-shared_preload_libraries = 'pg_stat_statements, pgaudit, plpgsql, plpgsql_check, pg_cron, pg_net, pgsodium, timescaledb, auto_explain, pg_tle, plan_filter, pg_backtrace' # (change requires restart)
+shared_preload_libraries = 'pg_stat_statements, pgaudit, plpgsql, plpgsql_check, pg_cron, pg_net, pgsodium, timescaledb, auto_explain, pg_tle, plan_filter' # (change requires restart)
jit_provider = 'llvmjit' # JIT library to use
diff --git a/nix/tests/prime.sql b/nix/tests/prime.sql
index 5116c419..d043945e 100644
--- a/nix/tests/prime.sql
+++ b/nix/tests/prime.sql
@@ -28,7 +28,6 @@ create extension if not exists lo;
create extension if not exists ltree;
create extension if not exists moddatetime;
create extension if not exists pageinspect;
-create extension if not exists pg_backtrace;
create extension if not exists pg_buffercache;
/*
[parent: 79c663bf85ad]