Assertions for Time Zone values don't align with Postgres

[jflorian]

Describe the bug

Attempted to set postgres_timezone and postgres_log_timezone to EDT (Eastern Daylight Time). This passes the assertion test provided here, but then the service fails to (re)start with the errors provided in the Output section below. Meanwhile, the service will start using the value America/Detroit, but that will not pass the assertion tests here.

In researching this a bit, I found this saying that "A time zone abbreviation, for example PST. Such a specification merely defines a particular offset from UTC, in contrast to full time zone names which can imply a set of daylight savings transition rules as well. The recognized abbreviations are listed in the pg_timezone_abbrevs view (see Section 54.31). You cannot set the configuration parameters TimeZone or log_timezone to a time zone abbreviation, but..."

Playbook

Please paste the playbook you are using. (Consider requirements.yml and
optionally the command you've invoked.)

---
- ansible.builtin.import_role:
    name: robertdebock.postgres

Output

postmaster[105490]: 2024-02-28 08:43:57.409 CST [105490] LOG:  invalid value for parameter "log_timezone": "EDT"
postmaster[105490]: 2024-02-28 08:43:57.409 CST [105490] FATAL:  configuration file "/var/lib/pgsql/data/postgresql.conf" contains errors

Environment

• Control node OS: Fedora 39
• Control node Ansible version: 9.1.0
• Control node Ansible Core version: 2.16.2
• Managed node OS: Fedora 39

Please consider sponsoring me.