From d9517e1712d07684d8a3ae89ecf996f682f551ed Mon Sep 17 00:00:00 2001
From: Wlodek Wencel <wlodek@isc.org>
Date: Wed, 28 Jun 2023 11:19:15 +0200
Subject: [PATCH] [#2950] fix pgsql 15 setup for unit tests

---
 hammer.py | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/hammer.py b/hammer.py
index ff8c5e9b67..59e971f4dd 100755
--- a/hammer.py
+++ b/hammer.py
@@ -1498,6 +1498,16 @@ def _configure_pgsql(system, features, revision):
     cmd += 'EOF\n"'
     execute(cmd, cwd='/tmp')
 
+    if system == 'fedora' and int(revision) >= 38 or \
+        system == 'debian' and int(revision) >= 12 or \
+        system == 'alpine' and float(revision) >= 3.17:
+        #TODO it needs detection of pgsql version, and apply this only 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 += 'EOF\n"'
+        execute(cmd, cwd='/tmp')
+
     cmd = """bash -c \"cat <<EOF | sudo -u postgres psql -U keatest keatest
         ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO keatest_readonly;\n"""
     cmd += 'EOF\n"'
-- 
2.47.2