add migration for pg_create_subscription grant

encima · soedirgo · commit a84c2c7d9773 · 2025-05-14T21:06:49.000+08:00
diff --git a/migrations/db/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql b/migrations/db/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql
@@ -0,0 +1,13 @@
+-- migrate:up
+DO $$
+DECLARE
+  major_version INT;
+BEGIN
+  SELECT current_setting('server_version_num')::INT / 10000 INTO major_version;
+
+  IF major_version >= 16 THEN
+    GRANT pg_create_subscription TO postgres;
+  END IF;
+END $$;
+
+-- migrate:down
