Skip to content

Latest commit

 

History

History
480 lines (331 loc) · 22.7 KB

CHANGELOG.rst

File metadata and controls

480 lines (331 loc) · 22.7 KB
Raw

Community PostgreSQL Collection Release Notes

Topics

v3.0.0

Release Summary

This is a major release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.4.2.

Major Changes

  • postgresql_pg_hba - remove the deprecated order argument. The sortorder sdu is hardcoded (ansible-collections#496).
  • postgresql_privs - remove the deprecated usage_on_types argument. Use the type option of the type argument to explicitly manipulate privileges on PG types (ansible-collections#208).
  • postgresql_query - remove the deprecated path_to_script and as_single_query arguments. Use the postgresql_script module to run queries from scripts (ansible-collections#189).
  • postgresql_user - move the deprecated privs argument removal to community.postgresql 4.0.0 (ansible-collections#493).
  • postgresql_user - remove the deprecated groups argument. Use the postgresql_membership module instead (ansible-collections#300).

v2.4.2

Release Summary

This is a bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after release 2.4.1.

Bugfixes

  • postgresql_db - when the task is completed successfully, close the database connection (ansible-collections#465).
  • postgresql_info - when the task is completed successfully, close the database connection (ansible-collections#465).
  • postgresql_ping - when the task is completed successfully, close the database connection (ansible-collections#465).
  • postgresql_privs - when the task is completed successfully, close the database connection (ansible-collections#465).

v2.4.1

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after release 2.4.0.

Bugfixes

v2.4.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.3.2.

Major Changes

  • postgresql_privs - the password argument is deprecated and will be removed in community.postgresql 4.0.0, use the login_password argument instead (ansible-collections#406).

Minor Changes

  • Add support for module_defaults with action_group all (ansible-collections#430).
  • postgresql - added new parameters ssl_cert and ssl_key for ssl connection (ansible-collections#424).
  • postgresql - when receiving the connection parameters, the PGPORT and PGUSER environment variables are checked. The order of assigning values environment variables -> default values -> set values (ansible-collections#311).
  • postgresql_query - a list of queries can be passed as the query argument's value, the results will be stored in the query_all_results return value (is not deprecated anymore, as well as query_list) (ansible-collections#312).

Bugfixes

  • postgresql_info - add support for non numeric extenstion version (ansible-collections#428).
  • postgresql_info - when getting information about subscriptions, check the list of available columns in the pg_subscription table (ansible-collections#429).
  • postgresql_privs - fix connect_params being ignored (ansible-collections#450).
  • postgresql_query - could crash under certain conditions because of a missing import to psycopg2.extras (ansible-collections#283).
  • postgresql_set - avoid throwing ValueError for IP addresses and other values that may look like a number, but which are not (ansible-collections#422).
  • postgresql_set - avoid wrong values for single-value parameters containing commas (ansible-collections#400).
  • postgresql_user - properly close DB connections to prevent possible connection limit exhaustion (ansible-collections#431).

v2.3.2

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after release 2.3.1.

Bugfixes

  • postgresql_pg_hba - fix changed return value for when overwrite is enabled (ansible-collections#378).
  • postgresql_privs - fix quoting of the schema parameter in SQL statements (ansible-collections#382).
  • postgresql_privs - raise an error when the objs: ALL_IN_SCHEMA is used with a value of type that is not table, sequence, function or procedure (ansible-collections#379).

v2.3.1

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after release 2.3.0.

Bugfixes

v2.3.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.2.0.

Minor Changes

  • postgresql_* - add the connect_params parameter dict to allow any additional libpg connection parameters (ansible-collections#329).

Bugfixes

  • postgresql_info - make arguments passed to SHOW command properly quoted to prevent the interpreter evaluating them (ansible-collections#314).
  • postgresql_pg_hba - support the connection types hostgssenc and hostnogssenc (ansible-collections#351).
  • postgresql_privs - add support for alter default privileges grant usage on schemas (ansible-collections#332).
  • postgresql_privs - cannot grant select on objects in all schemas; add the not-specified value to the schema parameter to make this possible (ansible-collections#332).
  • postgresql_set - avoid postgres puts extra quotes when passing values containing commas (ansible-collections#78).
  • postgresql_user - make the module idempotent when password is scram hashed (ansible-collections#301).

v2.2.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.5.

Major Changes

  • postgresql_user - the groups argument has been deprecated and will be removed in community.postgresql 3.0.0. Please use the postgresql_membership module to specify group/role memberships instead (ansible-collections#277).

Minor Changes

  • postgresql_membership - add the exact state value to be able to specify a list of only groups a user must be a member of (ansible-collections#277).
  • postgresql_pg_hba - add argument overwrite (bool, default: false) to remove unmanaged rules (ansible-collections#297).
  • postgresql_pg_hba - add argument rules_behavior (choices: conflict (default), combine) to fail when rules and normal rule-specific arguments are given or, when combine, use them as defaults for the rules items (ansible-collections#297).
  • postgresql_pg_hba - add argument rules to specify a list of rules using the normal rule-specific argument in each item (ansible-collections#297).

Bugfixes

v2.1.5

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.4

Bugfixes

  • Include PSF-license.txt file for plugins/module_utils/_version.py.
  • collection core functions - fix attribute error nonetype by always calling ensure_required_libs (ansible-collections#252).

v2.1.4

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.3.

Major Changes

  • The community.postgresql collection no longer supports Ansible 2.9 and ansible-base 2.10. While we take no active measures to prevent usage and there are no plans to introduce incompatible code to the modules, we will stop testing against Ansible 2.9 and ansible-base 2.10. Both will very soon be End of Life and if you are still using them, you should consider upgrading to the latest Ansible / ansible-core 2.11 or later as soon as possible (ansible-collections#245).

v2.1.3

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.2.

Major Changes

  • postgresql_user - the priv argument has been deprecated and will be removed in community.postgresql 3.0.0. Please use the postgresql_privs module to grant/revoke privileges instead (ansible-collections#212).

Bugfixes

v2.1.2

Release Summary

This is the patch release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.1.

Major Changes

  • postgresql_privs - the usage_on_types feature have been deprecated and will be removed in community.postgresql 3.0.0. Please use the type option with the type value to explicitly grant/revoke privileges on types (ansible-collections#207).

v2.1.1

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.1.0.

Bugfixes

  • module core functions - get rid of the deprecated psycopg2 connection alias database in favor of dbname when psycopg2 is 2.7+ (ansible-collections#196).
  • postgresql_query - cannot handle .sql file with \n at end of file (ansible-collections#180).

v2.1.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 2.0.0.

Major Changes

  • postgresql_query - the path_to_script and as_single_query options as well as the query_list and query_all_results return values have been deprecated and will be removed in community.postgresql 3.0.0. Please use the community.postgresql.postgresql_script module to execute statements from scripts (ansible-collections#189).

New Modules

  • postgresql_script - Run PostgreSQL statements from a file

v2.0.0

Release Summary

This is the major release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.7.0.

Major Changes

  • postgresql_query - the default value of the as_single_query option changes to yes. If the related behavior of your tasks where the module is involved changes, please adjust the parameter's value correspondingly (ansible-collections#85).

v1.6.1

Release Summary

This is the bugfix release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.6.1.

Bugfixes

  • Collection core functions - use vendored version of distutils.version instead of the deprecated Python standard library distutils (ansible-collections#179).
  • postgres_info - It now works on AWS RDS Postgres.
  • postgres_info - Specific info (namespaces, extensions, languages) of each database was not being shown properly. Instead, the info from the DB that was connected was always being shown (ansible-collections#172).

v1.6.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.5.0.

Bugfixes

  • postgresql_ext - Handle postgresql extension updates through path validation instead of version comparison (ansible-collections#129).

v1.5.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.4.0.

Minor Changes

Bugfixes

v1.4.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.3.0.

Minor Changes

v1.3.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.2.0.

Major Changes

  • postgresql_query - the default value of the as_single_query option will be changed to yes in community.postgresql 2.0.0 (ansible-collections#85).

Bugfixes

v1.2.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.1.1.

Minor Changes

  • postgresql_info - add the patch, full, and raw values of the version return value (ansible-collections#68).
  • postgresql_ping - add the patch, full, and raw values of the server_version return value (ansible-collections#70).

v1.1.1

Release Summary

This is the patch release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.1.0.

Bugfixes

v1.1.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.postgresql 1.0.0.

Minor Changes

  • postgresql_query - add as_single_query option to execute a script content as a single query to avoid semicolon related errors (ansible-collections#37).

Bugfixes

v1.0.0

Release Summary

This is the first proper release of the community.postgresql collection which is needed to include the collection in Ansible. This changelog does not contain any changes because there are no changes made since release 0.1.0.

v0.1.0

Release Summary

The community.postgresql continues the work on the Ansible PostgreSQL modules from their state in community.general 1.2.0. The changes listed here are thus relative to the modules community.general.postgresql_*.

Minor Changes

Bugfixes