community.postgresql

community.postgresql copied to clipboard

Add ansible-test integration for GHA

28

##### SUMMARY Like for the sanity tests, same external deps. ##### ISSUE TYPE - Feature Pull Request https://github.com/ansible-collections/community.postgresql/issues/154 ##### COMPONENT NAME docker testing with GHA ##### ADDITIONAL INFORMATION Only pg14...

klando

CI: integration testing against all supported Postgres versions

2

##### SUMMARY - Currently we tests using AZP and several distros with default Postgres versions available for each distro. See `.azure-pipelines/azure-pipelines.yml` file. - Postgres 14 has been recently released with...

Andersson007

postgresql_privs: Impossible to set column-level privileges

5

_Copied from https://github.com/ansible-collections/community.general/issues/118_ _Initially reported by @Andersson007_ _Copied from https://github.com/ansible/ansible/issues/18955_ _Initially reported by @jnv_ ##### ISSUE TYPE - Feature Idea ##### COMPONENT NAME postgresql_privs ##### ANSIBLE VERSION ``` ansible 2.3.0.0...

Andersson007

explicitly set "no_log: false" not taken into consideration by postgresql_user

7

##### SUMMARY when explicitly set no_log to false, the postgresql_user module seems not take it into consideration. This is important in the situation where the default value is set true...

ghost

also please pay attention to the tasks with the following conditions: ``` tests/integration/targets/postgresql_slot/tasks/postgresql_slot_initial.yml: when: ansible_facts.distribution == 'CentOS' and ansible_facts.distribution_major_version == '8' tests/integration/targets/postgresql_slot/tasks/postgresql_slot_initial.yml: when: (ansible_facts.distribution_major_version != '8' and ansible_facts.distribution == 'CentOS')...

klando

postgresql_cluster: manage psql clusters on a host - not just main

3

_Copied from https://github.com/ansible-collections/community.general/issues/122_ _Initially reported by @Andersson007_ _Copied from https://github.com/ansible/ansible/issues/67125_ _Initially reported by @DEvil0000_ **Before starting this**, please read the discussion in the initial [issue](https://github.com/ansible/ansible/issues/67125) ### SUMMARY ansible allows to...

Andersson007

postgresql_query has no option creates and no option removes

9

##### SUMMARY the shell module (and some other generic modules) have an option creates: and an option removes:. - creates: a filename, when it already exists, this step will not ...

sebasmannem

PostgreSQL community pinboard

7

[](https://github.com/ansible-collections/community.postgresql/issues)[](https://github.com/ansible-collections/community.postgresql/pulls) _Copied from [#435](https://github.com/ansible/community/issues/435) originally created by Dag Wieers_ We could collectively benefit from forming a [Working Group](https://github.com/ansible-collections/community.postgresql/wiki/PostgreSQL-Working-Group) related to PostgreSQL integration. We have quite some...

Andersson007

postgresql_user module fails with password on version 10.x if server is fips enabled

4

_From @Andersson007 on Apr 06, 2020 11:27_ _Copied from https://github.com/ansible/ansible/issues/41787_ _Initially reported by @jbscalia_ Postgresql_user needs to support AES-256 encryption. ##### SUMMARY If a server is FIPS-140-2 enabled, md5 is...

Akasurde

postgresql_user applying changes in check mode

13

##### SUMMARY I am currently creating a playbook to configure a postgresdb running on kubernetes and am facing unwanted behaviour with the dry run of the user provisioning. ##### ISSUE...

elmanolito