ansible-collections/community.postgresql
postgresql_alter_system fails for parameters with a reserved keyword after the dot (e.g., online_analyze.verbose)
开放
#940 创建于 2026年6月30日
help wanted
仓库指标
- 星标
- (142 个星标)
- PR 合并指标
- (PR 指标待抓取)
描述
SUMMARY
postgresql_alter_system fails for parameters with a reserved keyword after the dot (e.g., online_analyze.verbose)
ISSUE TYPE
- Bug Report
COMPONENT NAME
postgresql_alter_system
ANSIBLE VERSION
ansible [core 2.19.11]
COLLECTION VERSION
Collection Version
-------------------- -------
community.postgresql 4.2.0
OS / ENVIRONMENT
debian 12
STEPS TO REPRODUCE
- name: Apply postgres settings
become_user: "postgres"
community.postgresql.postgresql_alter_system:
login_unix_socket: "/var/lib/postrgesql" #or your socket
param: '"online_analyze.verbose"'
value: 'on'
-------------------------------------------------------------------
- name: Apply postgres settings
become_user: "postgres"
community.postgresql.postgresql_alter_system:
login_unix_socket: "/var/lib/postrgesql"
param: "online_analyze.verbose"
value: 'on'
ACTUAL RESULTS
[ERROR]: Task failed: Module failed: Parameter "online_analyze.verbose" does not exist
Origin: /myprocject/configure.yml:50:3
48 - meta: flush_handlers
49
50 - name: Apply postgres settings
^ column 3
fatal: [hostname]: FAILED! => {"changed": false, "msg": "Parameter \"online_analyze.verbose\" does not exist"}
-------------------------------------------------------------------
[ERROR]: Task failed: Module failed: Cannot set online_analyze.verbose: syntax error at or near "verbose"
LINE 1: ALTER SYSTEM SET online_analyze.verbose = 'on'
^
Origin: /myprocject/configure.yml:50:3
48 - meta: flush_handlers
49
50 - name: Apply postgres settings
^ column 3
fatal: [hostname]: FAILED! => {"changed": false, "msg": "Cannot set online_analyze.verbose: syntax error at or near \"verbose\"\nLINE 1: ALTER SYSTEM SET online_analyze.verbose = 'on'\n ^\n"}