TASK [pgsql : lookup pg packages & extensions names] *****************************************************************************************************
ok: [192.168.0.4]

TASK [pgsql : install postgres packages] *****************************************************************************************************************
failed: [192.168.0.4] (item=postgresql17*) => {"ansible_loop_var": "item", "changed": false, "item": "postgresql17*", "msg": "Failed to download packages: pkgconf-1.7.3-10.el9.x86_64: Cannot download, all mirrors were already tried without success", "results": []}
failed: [192.168.0.4] (item=wal2json_17*,pg_repack_17*,pgvector_17*) => {"ansible_loop_var": "item", "changed": false, "item": "wal2json_17*,pg_repack_17*,pgvector_17*", "msg": "Failed to download packages: pgvector_17-llvmjit-0.8.0-1PGDG.rhel9.x86_64: Cannot download, all mirrors were already tried without success", "results": []}
failed: [192.168.0.4] (item=patroni,patroni-etcd,pgbouncer,pgbackrest,pg_exporter,pgbadger,vip-manager) => {"ansible_loop_var": "item", "changed": false, "item": "patroni,patroni-etcd,pgbouncer,pgbackrest,pg_exporter,pgbadger,vip-manager", "msg": "Failed to download packages: python3-dns-2.6.1-3.el9.noarch: Cannot download, all mirrors were already tried without success", "results": []}

PLAY RECAP ***********************************************************************************************************************************************
192.168.0.4 : ok=237 changed=135 unreachable=0 failed=1 skipped=54 rescued=0 ignored=0
localhost : ok=3 changed=0 unreachable=0 failed=0 skipped=4 rescued=0 ignored=0

$ cat /etc/os-release
NAME="Rocky Linux"
VERSION="9.5 (Blue Onyx)"
ID="rocky"
ID_LIKE="rhel centos fedora"
VERSION_ID="9.5"
PLATFORM_ID="platform:el9"
PRETTY_NAME="Rocky Linux 9.5 (Blue Onyx)"
ANSI_COLOR="0;32"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:rocky:rocky:9::baseos"
HOME_URL="https://rockylinux.org/"
VENDOR_NAME="RESF"
VENDOR_URL="https://resf.org/"
BUG_REPORT_URL="https://bugs.rockylinux.org/"
SUPPORT_END="2032-05-31"
ROCKY_SUPPORT_PRODUCT="Rocky-Linux-9"
ROCKY_SUPPORT_PRODUCT_VERSION="9.5"
REDHAT_SUPPORT_PRODUCT="Rocky Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="9.5"

$ uname -a
Linux h.pigsty 5.14.0-503.26.1.el9_5.x86_64#1 SMP PREEMPT_DYNAMIC Wed Feb 19 16:28:19 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

$ cat pigsty.yml|grep version
version: v3.3.0 # pigsty version string
pg_version: 17 # default postgres version