Alter database connection limit 0 #879
Description
SUMMARY
I am trying to use postgresql_db module to set connection limit to certain db to 0.
After task is done I dont have any error messages but connection limit to my db is still default.
ISSUE TYPE
- Bug Report
COMPONENT NAME
postgresql_db
ANSIBLE VERSION
ansible-playbook [core 2.18.8]
COLLECTION VERSION
Collection Version
-------------------- -------
community.postgresql 4.1.0
# /home/evgeny/.local/lib/python3.12/site-packages/ansible_collections
Collection Version
-------------------- -------
community.postgresql 3.14.2
# /usr/lib/python3/dist-packages/ansible_collections
Collection Version
-------------------- -------
community.postgresql 3.3.0
CONFIGURATION
CONFIG_FILE() = /home/evgeny/Catapulto/ansible/ansible.cfg
DEFAULT_ROLES_PATH(/home/evgeny/Catapulto/ansible/ansible.cfg) = ['/home/evgeny/Catapulto/ansible/roles']
HOST_KEY_CHECKING(/home/evgeny/Catapulto/ansible/ansible.cfg) = False
INTERPRETER_PYTHON(/home/evgeny/Catapulto/ansible/ansible.cfg) = /usr/bin/python3
OS / ENVIRONMENT
Ubuntu 24.04.2 LTS
STEPS TO REPRODUCE
Just run postgresql_db module with conn_limit: 0
- name: Set connection limit to 0
community.postgresql.postgresql_db:
login_user: "{{ db_user }}"
login_host: "{{ db_host }}"
login_port: "{{ db_port }}"
login_password: "{{ db_password }}"
name: "{{ item }}"
conn_limit: "0"
loop: "{{ database_list }}"EXPECTED RESULTS
I would expect to receive any error message or new value of connection limit to my database
ACTUAL RESULTS
No any error messages
changed: [testf.ctplt.ru] => (item=catapulto) => {"ansible_loop_var": "item", "changed": true, "db": "catapulto", "executed_commands": ["ALTER DATABASE \"catapulto\" CONNECTION LIMIT 0"], "item": "catapulto"}