community.postgresql
community.postgresql copied to clipboard
ansible-collections
Manage PostgreSQL with Ansible
##### SUMMARY Hi everyone! This collection is a part of Ansible package and is looking for new maintainers and contributors. To learn how to contribute to the collection and how...
##### SUMMARY Test PR. Do NOT merge Relates to https://github.com/ansible-collections/community.postgresql/pull/356
##### SUMMARY The postgresql_table module currently doesn't have the functionality to create a composite primary key spanning multiple columns. This would be required for some table designs though ##### ISSUE...
From a user perspective I think it would be more convenient to have a `comment` argument wherever an object is created. To only change a comment, they need to be...
It doesn't seem that postgresql_privs is always idempotent as it should be. The following always makes a change even on repetitive runs: ``` - name: Revoke default public privileges on...
##### SUMMARY Create, alter or drop PostgreSQL functions. ##### ISSUE TYPE - Module development ##### COMPONENT NAME postgresql_funcs ##### ADDITIONAL INFORMATION Example usage: ```yaml - name: Sum of integers function...
**SUMMARY** Can't revoke the functions from user with community.postgresql.postgresql_privs. **ISSUE TYPE** * Bug Report **COMPONENT NAME** postgresql_privs **COLLECTION VERSION** community.general 8.5.0 **ACTUAL RESULTS** The revoke FUNCTIONS is missing in the...
##### SUMMARY Ability to begin/commit/rollback a transaction. This can help to group certain queries together so they all take effect at once. ##### ISSUE TYPE - Feature Idea ##### COMPONENT...
##### SUMMARY When running `pg_upgrade`, PG will create a file called `update_extensions.sql` that you're supposed to use to upgrade all the extensions after the upgrade. However, passing this script to...
##### SUMMARY ldapbindpasswd in options which includes '#' creates faulty pg_hba lines While a hashmark in a password might be ugly I cannot change this ##### ISSUE TYPE - Bug...
