mirror of
https://github.com/hanzoai/postgres.git
synced 2026-10-30 18:33:07 +00:00
zeekay
ef8051be80
- Set documentdb_core.rum_library_load_option = 'try_documentdb_extended_rum' (was defaulting to 'require' which causes FATAL when .so has missing deps) - Wrap documentdb extensions in DO blocks so init script failures don't abort PG startup — PG stays healthy even if DocumentDB fails to load
21 lines
731 B
SQL
21 lines
731 B
SQL
-- Hanzo SQL: Enable extensions
|
|
-- Using DO blocks so individual extension failures don't abort the init script.
|
|
CREATE EXTENSION IF NOT EXISTS vector;
|
|
CREATE EXTENSION IF NOT EXISTS pg_cron;
|
|
CREATE EXTENSION IF NOT EXISTS postgis;
|
|
CREATE EXTENSION IF NOT EXISTS tsm_system_rows;
|
|
|
|
-- DocumentDB extensions may fail if shared_preload_libraries config differs;
|
|
-- wrap in DO block to keep PG running regardless.
|
|
DO $$ BEGIN
|
|
CREATE EXTENSION IF NOT EXISTS documentdb_core;
|
|
EXCEPTION WHEN OTHERS THEN
|
|
RAISE WARNING 'documentdb_core extension not loaded: %', SQLERRM;
|
|
END $$;
|
|
|
|
DO $$ BEGIN
|
|
CREATE EXTENSION IF NOT EXISTS documentdb;
|
|
EXCEPTION WHEN OTHERS THEN
|
|
RAISE WARNING 'documentdb extension not loaded: %', SQLERRM;
|
|
END $$;
|