Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit92c792d

Browse files
committed
fix: update ext custom scripts to follow changes in Salt
1 parent578be5d commit92c792d

File tree

2 files changed

+29
-10
lines changed

2 files changed

+29
-10
lines changed

‎ansible/files/postgresql_extension_custom_scripts/pgmq/after-create.sql‎

Lines changed: 13 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
do $$
22
declare
33
extoidoid := (selectoidfrom pg_extensionwhere extname='pgmq');
4+
extversiontext := (select extversionfrom pg_extensionwhere extname='pgmq');
45
r record;
56
cls pg_class%rowtype;
67
begin
@@ -18,8 +19,13 @@ begin
1819
physical backups everywhere
1920
*/
2021
-- Detach and delete the official function
21-
alter extension pgmq drop functionpgmq.drop_queue(TEXT);
22-
dropfunctionpgmq.drop_queue(TEXT);
22+
if extversion='1.4.4' then
23+
alter extension pgmq drop functionpgmq.drop_queue;
24+
dropfunctionpgmq.drop_queue;
25+
else-- 1.5.1+
26+
alter extension pgmq drop functionpgmq.drop_queue(TEXT);
27+
dropfunctionpgmq.drop_queue(TEXT);
28+
end if;
2329

2430
-- Create and reattach the patched function
2531
CREATEFUNCTIONpgmq.drop_queue(queue_nameTEXT)
@@ -134,7 +140,11 @@ BEGIN
134140
END;
135141
$func$ LANGUAGE plpgsql;
136142

137-
alter extension pgmq add functionpgmq.drop_queue(TEXT);
143+
if extversion='1.4.4' then
144+
alter extension pgmq add functionpgmq.drop_queue;
145+
else-- 1.5.1+
146+
alter extension pgmq add functionpgmq.drop_queue(TEXT);
147+
end if;
138148

139149

140150
update pg_extensionset extowner='postgres'::regrolewhere extname='pgmq';
Lines changed: 16 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,17 @@
1-
grant usageon schema vault to postgres withgrant option;
2-
grantselect,delete, truncate,referencesonvault.secrets,vault.decrypted_secrets to postgres withgrant option;
3-
grant executeon functionvault.create_secret,vault.update_secret,vault._crypto_aead_det_decrypt to postgres withgrant option;
1+
do $$
2+
declare
3+
extversiontext := (select extversionfrom pg_extensionwhere extname='supabase_vault');
4+
begin
5+
set local search_path='';
46

5-
-- service_role used to be able to manage secrets in Vault <=0.2.8 because it had privileges to pgsodium functions
6-
grant usageon schema vault to service_role;
7-
grantselect,deleteonvault.secrets,vault.decrypted_secrets to service_role;
8-
grant executeon functionvault.create_secret,vault.update_secret,vault._crypto_aead_det_decrypt to service_role;
7+
if extversion!='0.2.8' then
8+
grant usageon schema vault to postgres withgrant option;
9+
grantselect,delete, truncate,referencesonvault.secrets,vault.decrypted_secrets to postgres withgrant option;
10+
grant executeon functionvault.create_secret,vault.update_secret,vault._crypto_aead_det_decrypt to postgres withgrant option;
11+
12+
-- service_role used to be able to manage secrets in Vault <=0.2.8 because it had privileges to pgsodium functions
13+
grant usageon schema vault to service_role;
14+
grantselect,deleteonvault.secrets,vault.decrypted_secrets to service_role;
15+
grant executeon functionvault.create_secret,vault.update_secret,vault._crypto_aead_det_decrypt to service_role;
16+
end if;
17+
end $$;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp