17750: Update example postgresql configuration for Centos 7

Arvados-DCO-1.1-Signed-off-by: Javier Bértoli <jbertoli@curii.com>

diff --git a/test/salt/pillar/examples/postgresql.sls b/test/salt/pillar/examples/postgresql.sls
index 5d800ec7f3bd8e9a55caf06c9ebd1178115b5682..0bf33570e4de2205eeb037fc330d713f7616648e 100644 (file)
--- a/test/salt/pillar/examples/postgresql.sls
+++ b/test/salt/pillar/examples/postgresql.sls
@@ -1,9 +1,28 @@
 ---
 ---

+# Copyright (C) The Arvados Authors. All rights reserved.
+#
+# SPDX-License-Identifier: AGPL-3.0
+

 ### POSTGRESQL
 postgres:
 ### POSTGRESQL
 postgres:

-  use_upstream_repo: false
+  # Centos-7's postgres package is too old, so we need to force using upstream's
+  # This is not required in Debian's family as they already ship with PG +11
+  {%- if salt['grains.get']('os_family') == 'RedHat' %}
+  use_upstream_repo: true
+  version: '12'
+
+  pkgs_deps:
+    - libicu
+    - libxslt
+    - systemd-sysv
+
+  pkgs_extra:
+    - postgresql12-contrib
+
+  {%- else %}

   pkgs_extra:
     - postgresql-contrib
   pkgs_extra:
     - postgresql-contrib

+  {%- endif %}

   postgresconf: |-
     listen_addresses = '*'  # listen on all interfaces
     #ssl = on
   postgresconf: |-
     listen_addresses = '*'  # listen on all interfaces
     #ssl = on