add huge_pages_status to postgresql_info output

[hunleyd]

SUMMARY

With the release of PG 17, we should include the value of huge_pages_status in the output of postgresql_info to make it easy to determine if huge pages are in use by PG or not

ISSUE TYPE

• Feature Idea

COMPONENT NAME

postgresql_info

ADDITIONAL INFORMATION

- name: Collect PostgreSQL version and extensions
  become: true
  become_user: postgres
  community.postgresql.postgresql_info:
  register: 'pginfo'

- ansible.builtin.assert:
    that:
      - pginfo['huge_pages_status']
    fail_msg: 'PG was not able to allocate huge pages'

[hunleyd]

thoughts @Andersson007 ?

[Andersson007]

@hunleyd SGTM, thanks for reporting the feature request, SGTM, would you like to add it yourself? If no, please add the help wanted label

[hunleyd]

i've added the label. i'd love to look at it myself, but if someone can get to it faster, that's great.

[Andersson007]

@hunleyd i took a look and i see in the output:

        "huge_pages_status": {
            "boot_val": "unknown",
            "context": "internal",
            "max_val": "",
            "min_val": "",
            "pending_restart": false,
            "pretty_val": "off",
            "setting": "off",
            "sourcefile": "",
            "unit": "",
            "vartype": "enum"
        },

or did you mean something different?