ansible-collections/community.postgresql

postgresql_table does not track changes in unlogged

Open

#878 opened on Aug 5, 2025

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Python (116 forks)auto 404
enhancementhelp wanted

Repository metrics

Stars
 (142 stars)
PR merge metrics
 (PR metrics pending)

Description

SUMMARY

the community.postgresql.postgresql_table is able to create an unlogged table but is not able to change it from logged to unlogged.

ISSUE TYPE
  • Bug Report
COMPONENT NAME

community.postgresql.postgresql_table

ANSIBLE VERSION
 > ansible --version
ansible [core 2.17.12]
  config file = None
  configured module search path = ['/home/ajackson/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /home/ajackson/monorepo/.venv/lib/python3.10/site-packages/ansible
  ansible collection location = /home/ajackson/.ansible/collections:/usr/share/ansible/collections
  executable location = /home/ajackson/monorepo/.venv/bin/ansible
  python version = 3.10.12 (main, May 27 2025, 17:12:29) [GCC 11.4.0] (/home/ajackson/monorepo/.venv/bin/python)
  jinja version = 3.1.6
  libyaml = True
COLLECTION VERSION

-->

 > ansible-galaxy collection list community.general

# /home/ajackson/.ansible/collections/ansible_collections
Collection        Version
----------------- -------
community.general 11.1.0

OS / ENVIRONMENT

Linux

STEPS TO REPRODUCE

create a table using community.postgresql.postgresql_table with unlogged: true. Then subsequently change unlogged to false. Run the ansible again, it will show no changes and make no attempt to change the table from unlogged to logged.

EXPECTED RESULTS

I would expect the table to change from unlogged to logged and for a change to show up in the summary.

ACTUAL RESULTS

Ansible does not make any change to the table and shows up as OK in the summary.

Contributor guide