[3.14.0] postgresql_alter_system module is trying to int a non-int param

[badfiles]

ENV:
ansible [core 2.16.14]
python version = 3.12.3 (main, Feb 4 2025, 14:48:35) [GCC 13.3.0] (/usr/bin/python3)

OS:
NAME="AlmaLinux"
VERSION="9.5 (Teal Serval)"
ID="almalinux"
ID_LIKE="rhel centos fedora"
VERSION_ID="9.5"

postgres (PostgreSQL) 15.13

postgres=# SELECT setting, unit, context, vartype, enumvals,
                 boot_val, min_val, max_val, pending_restart
                 FROM pg_catalog.pg_settings where name = 'random_page_cost'
;
 setting | unit | context | vartype | enumvals | boot_val | min_val |   max_val    | pending_restart 
---------+------+---------+---------+----------+----------+---------+--------------+-----------------
 1.1     |      | user    | real    |          | 4        | 0       | 1.79769e+308 | f
(1 row)

An exception occurred during task execution. To see the full traceback, use -vvv. The error was: ValueError: invalid literal for int() with base 10: '1.79769e+308'
failed: [****] (item={'name': 'random_page_cost', 'value': '1.1'}) => changed=false 
  ansible_loop_var: item
  item:
    name: random_page_cost
    value: '1.1'
  module_stderr: |-
    Traceback (most recent call last):
      File "<stdin>", line 107, in <module>
      File "<stdin>", line 99, in _ansiballz_main
      File "<stdin>", line 47, in invoke_module
      File "/usr/lib64/python3.9/runpy.py", line 225, in run_module
        return _run_module_code(code, init_globals, run_name, mod_spec)
      File "/usr/lib64/python3.9/runpy.py", line 97, in _run_module_code
        _run_code(code, mod_globals, init_globals,
      File "/usr/lib64/python3.9/runpy.py", line 87, in _run_code
        exec(code, run_globals)
      File "/tmp/ansible_community.postgresql.postgresql_alter_system_payload_g5aegz2y/ansible_community.postgresql.postgresql_alter_system_payload.zip/ansible_collections/community/postgresql/plugins/modules/postgresql_alter_system.py", line 874, in <module>
      File "/tmp/ansible_community.postgresql.postgresql_alter_system_payload_g5aegz2y/ansible_community.postgresql.postgresql_alter_system_payload.zip/ansible_collections/community/postgresql/plugins/modules/postgresql_alter_system.py", line 849, in main
      File "/tmp/ansible_community.postgresql.postgresql_alter_system_payload_g5aegz2y/ansible_community.postgresql.postgresql_alter_system_payload.zip/ansible_collections/community/postgresql/plugins/modules/postgresql_alter_system.py", line 575, in convert_ret_vals
    ValueError: invalid literal for int() with base 10: '1.79769e+308'
  module_stdout: ''
  msg: |-
    MODULE FAILURE
    See stdout/stderr for the exact error

however another real param is processed correctly

ok: [***] => (item={'name': 'checkpoint_completion_target', 'value': '0.9'})

[Andersson007]

@badfiles hello, thanks for reporting the issue! I've reproduced and submitted a fix #854
In the fix, I suggest just returning it as string. Yes, we could convert it to int but it'll have a few hundreds of digits (this is the only max value written in this notation) which is hard to deal with when it's int

[Andersson007]

@badfiles the patched versions 4.0.1 and 3.14.1 are on Galaxy https://galaxy.ansible.com/ui/repo/published/community/postgresql/ , please upgrade. Thanks once more for the contribution by reporting the bug!
And thanks the folks in the PR for reviewing and merging the patch quickly!