community.postgresql
community.postgresql copied to clipboard
ansible-collections
Manage PostgreSQL with Ansible
##### SUMMARY > hm cycle=dict(type='bool', default=False), looks like a type mismatch (if we take a look at arg_spec in main). > change it to type bool and sample: 'false' to...
##### SUMMARY Fixes https://github.com/ansible-collections/community.postgresql/issues/332 Fixes https://github.com/ansible-collections/community.postgresql/issues/333 Test task 332 executes the following queries: ``` ALTER DEFAULT PRIVILEGES REVOKE ALL ON SCHEMAS FROM \"ansible_db_user3\"; ALTER DEFAULT PRIVILEGES GRANT USAGE ON SCHEMAS...
##### SUMMARY I have encountered the same problem described on this closed issue: https://github.com/ansible/ansible/issues/63273 There was a patch made for it, but for whatever reason that merge request and the...
##### SUMMARY I believe that if the script file has **N** SQL queries, it should return **N** results. But today it **only** returns the **last** SQL Query in the script...
##### SUMMARY The `PGPORT` environment variable is ignored. Because of that, we have to explicitly set the `port` variable in all the ansible module invocation, which is quite unfortunate. #####...
##### SUMMARY I want to alter default permissions to grant select on all tables in all schemas, using community.postgresql.postgresql_privs, but this does not seem to be possible as it defaults...
### Summary I am not able to use the variable list as postgreSQL Json argument in the psql query PostgreSQL accept Json in format ["[email protected]","[email protected]"] On manipulating variable list ["[email protected]",...
Release plan
##### SUMMARY _(partially copied from https://github.com/ansible-collections/community.crypto/issues/74 , thanks to @felixfontein)_ We should decide on how to release this collection (w.r.t. versioning). Small collections like this one don't need a complex...
##### SUMMARY Show command in postgresql_info is not protected by brackets, when a parameter contain a key word (like analyze), it raises an SQL syntax error. ##### ISSUE TYPE -...
