[BUG] nothing provides libicui18n.so.52.1()(64bit) for postgresql10

[noelmcloughlin]

Your setup

Formula commit hash / release tag

Versions reports (master & minion)

opensuse15:/home/vagrant # salt-call --versions-report --local
Salt Version:
           Salt: 3000

Dependency Versions:
           cffi: 1.13.2
       cherrypy: 18.3.0
       dateutil: Not Installed
      docker-py: Not Installed
          gitdb: Not Installed
      gitpython: Not Installed
         Jinja2: 2.10.1
        libgit2: 0.28.4
       M2Crypto: 0.35.2
           Mako: Not Installed
   msgpack-pure: Not Installed
 msgpack-python: 0.5.6
   mysql-python: Not Installed
      pycparser: 2.17
       pycrypto: Not Installed
   pycryptodome: Not Installed
         pygit2: 0.28.2
         Python: 3.6.10 (default, Jan 16 2020, 09:12:04) [GCC]
   python-gnupg: Not Installed
         PyYAML: 5.1.2
          PyZMQ: 17.0.0
          smmap: Not Installed
        timelib: Not Installed
        Tornado: 4.5.3
            ZMQ: 4.2.3

System Versions:
           dist:
         locale: UTF-8
        machine: x86_64
        release: 5.3.18-lp152.50-default
         system: Linux
        version: Not Installed

NAME="openSUSE Leap"
VERSION="15.2"
ID="opensuse-leap"
ID_LIKE="suse opensuse"
VERSION_ID="15.2"
PRETTY_NAME="openSUSE Leap 15.2"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:opensuse:leap:15.2"
BUG_REPORT_URL="https://bugs.opensuse.org"
HOME_URL="https://www.opensuse.org/"

Pillar / config used

postgres:
  users:
    airflow:
      ensure: present
      password: airflow
      createdb: true
      inherit: true
      createroles: true
      replication: true
  databases:
    airflow:
      owner: airflow
  acls:
    - ['local', 'airflow', 'airflow', 'md5']
    - ['local', 'all', 'all', 'peer']
    - ['host', 'all', 'all', '127.0.0.1/32', 'md5']
    - ['host', 'all', 'all', '::1/128', 'md5']
    - ['local', 'replication', 'all', 'peer']
    - ['host', 'replication', 'all', '127.0.0.1/32', 'md5']
    - ['host', 'replication', 'all', '::1/128', 'md5']

---

Bug details

Describe the bug

The default configuration for openSUSE does not work?

What is the correct pillar for OpenSUSE Leap 15.2?

Steps to reproduce the bug

vagrant@opensuse15:~> sudo salt-call state.highstate --local
[ERROR   ] Command '['systemd-run', '--scope', 'zypper', '--non-interactive', '--no-refresh', 'install', '--auto-agree-with-licenses', '--name', '--force', '-
-force-resolution', '--from', 'pgdg-sles-10', 'postgresql10-server']' failed with return code: 4
[ERROR   ] stdout: Loading repository data...
Reading installed packages...
Forcing installation of 'postgresql10-server-10.15-1PGDG.sles12.x86_64' from repository 'pgdg-sles-10'.
Resolving package dependencies...

Problem: nothing provides libicui18n.so.52.1()(64bit) needed by postgresql10-server-10.15-1PGDG.sles12.x86_64
 Solution 1: do not install postgresql10-server-10.15-1PGDG.sles12.x86_64
 Solution 2: break postgresql10-server-10.15-1PGDG.sles12.x86_64 by ignoring some of its dependencies

Choose from above solutions by number or cancel [1/2/c/d/?] (c): c
[ERROR   ] stderr: Running scope as unit: run-r7175d3ce9e5745d59c157a355955f6cf.scope
[ERROR   ] retcode: 4
[ERROR   ] An error was encountered while installing package(s): Zypper command failure: Running scope as unit: run-r7175d3ce9e5745d59c157a355955f6cf.scope
[ERROR   ] User postgres is not available Group postgres is not available
[ERROR   ] An exception occurred in this state: Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/salt/modules/cmdmod.py", line 442, in _run
    pwd.getpwnam(runas)
KeyError: "getpwnam(): name not found: 'postgres'"

During handling of the above exception, another exception occurred:

Expected behaviour

Attempts to fix the bug

Additional context

[noelmcloughlin]

I remember https://github.com/saltstack-formulas/postgres-formula/pull/176 hardcoded suse-12 because there was no repo available for suse-15.

[noelmcloughlin]

303