From be86521a42c322b586cbd121adcd6e9fcfbbbefd Mon Sep 17 00:00:00 2001
From: Slawek Figiel <slawek@isc.org>
Date: Wed, 22 May 2024 12:31:30 +0200
Subject: [#2773] Update Hammer queries

---
 hammer.py | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'hammer.py')

diff --git a/hammer.py b/hammer.py
index 17182bef4a..7ceae2fbfe 100755
--- a/hammer.py
+++ b/hammer.py
@@ -1556,9 +1556,8 @@ def _configure_pgsql(system, revision, features):
     execute(cmd, cwd='/tmp')
 
     # This is needed for postgres >= 15
-    cmd = """bash -c \"cat <<EOF | sudo -u postgres psql postgres
-        GRANT ALL ON DATABASE keatest TO keatest;
-        ALTER DATABASE keatest OWNER TO keatest;\n"""
+    cmd = """bash -c \"cat <<EOF | sudo -u postgres psql -U postgres -d keatest
+        GRANT ALL PRIVILEGES ON SCHEMA public TO keatest;\n"""
     cmd += 'EOF\n"'
     execute(cmd, cwd='/tmp')
 
-- 
cgit v1.2.3