Fix postgresql_db for Postgres 17+

ansible-collections / community.postgresql

Manage PostgreSQL with Ansible

https://galaxy.ansible.com/ui/repo/published/community/postgresql/

Other

111 stars 90 forks source link

Fix postgresql_db for Postgres 17+ #731

Closed cameronmurdoch closed 2 months ago

cameronmurdoch commented 2 months ago

SUMMARY

Fix postgresql_db for Postgres 17+ due to a column name change in pg_database.

Fixes: #729

ISSUE TYPE

Bugfix Pull Request

COMPONENT NAME

postgresql_db

ADDITIONAL INFORMATION

This appears to be the minimum required change for postgresql_db to work as expected with Postgres17 or higher whilst maintaining backwards compatibility.

Andersson007 commented 2 months ago

@cameronmurdoch thanks for the contribution! @hunleyd thanks for reviewing!

Andersson007 commented 2 months ago

The community.postgresql collection version 3.6.0 has been released! Among other changes, it contains fixes for some modules to work with PostgreSQL 17 beta. Thanks to everyone involved!

Andersson007 commented 2 months ago

@cameronmurdoch i don't remember if i already told you (sorry for the noise if i did), we chat on Matrix and have a forum group, see the communication section of the README for details. FYI