Skip to content

Latest commit

 

History

History
742 lines (516 loc) · 35.2 KB

CHANGELOG.rst

File metadata and controls

742 lines (516 loc) · 35.2 KB
Raw

Community PostgreSQL Collection Release Notes

Topics

v3.9.1

Release Summary

This is a patch release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Bugfixes

  • postgresql_pg_hba - fixes #777 the module will ignore the 'address' and 'netmask' options again when the contype is 'local' (#779)

v3.9.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_pg_hba - changes ordering of entries that are identical except for the ip-range, but only if the ranges are of the same size, this isn't breaking as ranges of equal size can't overlap (#772)
  • postgresql_pg_hba - orders auth-options alphabetically, this isn't breaking as the order of those options is not relevant to postgresql (#772)

v3.8.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_pg_hba - show the number of the line with the issue if parsing a file fails (#766)
  • postgresql_publication - add possibility of creating publication with column list (#763).

Bugfixes

  • postgresql_pg_hba - fixes #420 by properly handling hash-symbols in quotes (#766)
  • postgresql_pg_hba - fixes #705 by preventing invalid strings to be written (#761)
  • postgresql_pg_hba - fixes #730 by extending the key we use to identify a rule with the connection type (#770)
  • postgresql_pg_hba - improves parsing of quoted strings and escaped newlines (#761)
  • postgresql_user - doesn't take password_encryption into account when checking if a password should be updated (#688).

v3.7.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_set - adds the queries return value to return executed DML statements.

Bugfixes

  • postgresql_set - fixes resetting logic to allow resetting shared_preload_libraries with reset: true (#744).
  • postgresql_set - forbids resetting shared_preload_libraries by passing an empty string (#744).

v3.6.1

Release Summary

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

Bugfixes

  • postgresql_user - remove a comment from unit tests that breaks pre-compile (#737).

v3.6.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_privs - adds support for granting and revoking privileges on foreign tables (#724).
  • postgresql_subscription - adds support for managing subscriptions in the situation where the subconninfo column is unavailable (such as in CloudSQL) (#726).

Bugfixes

  • postgresql_db - fix issues due to columns in pg_database changing in Postgres 17. (#729).
  • postgresql_info - Use a server check that works on beta and rc versions as well as on actual releases.

v3.5.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgres - add support for postgres infinity timestamps by replacing them with datetime.min / datetime.max values (#714).
  • postgresql_publication - add the tables_in_schema argument to implement FOR TABLES IN SCHEMA feature (#709).
  • postgresql_user - adds the configuration argument that allows to manage user-specific default configuration (#598).

Bugfixes

  • postgres - psycopg2 automatically sets the datestyle on the connection to iso whenever it encounters a datestyle configuration it doesn't recognize, but psycopg3 does not. Fix now enforces iso datestyle when using psycopg3 (#711).

v3.4.1

Release Summary

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

Bugfixes

  • postgresql_db - restore custom format as file instead of stdin to allow the use of --job flag in target_opts (#594).
  • postgresql_ext - Reconnect before upgrade to avoid accidental load of the upgraded extension (#689).
  • postgresql_idx - consider schema name when checking for index (#692). Index names are only unique within a schema. This allows using the same index name in multiple schemas.
  • postgresql_privs - Enables the ability to revoke functions from user (#687).

v3.4.0

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_db - add the icu_locale argument (#666).
  • postgresql_db - add the locale_provider argument (#666).

Bugfixes

  • postgresql_privs - fix a failure when altering privileges with grant_option: true (#668).

v3.3.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgresql_db - add the comment argument (#614).
  • postgresql_ext - add the comment argument (#354).
  • postgresql_publication - add the comment argument (#354).
  • postgresql_schema - add the comment argument (#354).
  • postgresql_subscription - add the comment argument (#354).
  • postgresql_tablespace - add the comment argument (#354).

Bugfixes

  • postgresql_query - now reports not changed for queries starting with "SHOW" (#592).
  • postgresql_user - module failed when running against an SQL_ASCII encoded database as the user's current password was returned as bytes as opposed to a str. Fix now checks for this case and decodes the bytes as an ascii encoded string. (#584).

v3.2.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

  • postgres modules - added support for Psycopg 3 library (#517).
  • postgresql_owner - added support at new object types (#555).

Bugfixes

  • postgresql_info - fix SQL syntax issue (#570).

v3.1.0

Release Summary

This is the minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Major Changes

  • postgres modules - the minimum version of psycopg2 library the collection supports is 2.5.1 (#556).

Minor Changes

  • Collection core functions - use get_server_version in all modules (#518)."
  • Collection core functions - use common cursor arguments in all modules (#522)."
  • postgresql_ext - added idempotence always both in standard and in check mode (#545).
  • postgresql_ext - added idempotence when version=latest (#504).
  • postgresql_ext - added prev_version and version return values (#545).
  • postgresql_ext - added queries in module output also in check mode (#545).
  • postgresql_ext - improved error messages (#545).
  • postgresql_privs - added idempotence when roles=PUBLIC (#502).
  • postgresql_privs - added parameters privileges support for PostgreSQL 15 or higher (#481).
  • postgresql_privs - added support for implicit roles CURRENT_ROLE, CURRENT_USER, and SESSION_USER (#502).
  • postgresql_tablespace - added idempotence when dropping a non-existing tablespace (#554).

Deprecated Features

  • postgresql_lang - the module has been deprecated and will be removed in community.postgresql 4.0.0. Please use the postgresql_ext module instead (#559).

Bugfixes

  • postgresql_ext - fixed queries return value name in documentation (#545).
  • postgresql_privs - fixed error message and documentation (#510).
  • postgresql_set - fixed GUC_LIST_QUOTE parameters (#521).
  • postgresql_set - fixed error message in param_set function (#505).

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 (#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 (#208).
  • postgresql_query - remove the deprecated path_to_script and as_single_query arguments. Use the postgresql_script module to run queries from scripts (#189).
  • postgresql_user - move the deprecated privs argument removal to community.postgresql 4.0.0 (#493).
  • postgresql_user - remove the deprecated groups argument. Use the postgresql_membership module instead (#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 (#465).
  • postgresql_info - when the task is completed successfully, close the database connection (#465).
  • postgresql_ping - when the task is completed successfully, close the database connection (#465).
  • postgresql_privs - when the task is completed successfully, close the database connection (#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

  • postgresql_privs - fix a breaking change related to handling the password argument (#463).

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 (#406).

Minor Changes

  • Add support for module_defaults with action_group all (#430).
  • postgresql - added new parameters ssl_cert and ssl_key for ssl connection (#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 (#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) (#312).

Bugfixes

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

  • postgresql_privs - fails with type=default_privs, privs=ALL, objs=ALL_DEFAULT (#373).

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 (#329).

Bugfixes

  • postgresql_info - make arguments passed to SHOW command properly quoted to prevent the interpreter evaluating them (#314).
  • postgresql_pg_hba - support the connection types hostgssenc and hostnogssenc (#351).
  • postgresql_privs - add support for alter default privileges grant usage on schemas (#332).
  • postgresql_privs - cannot grant select on objects in all schemas; add the not-specified value to the schema parameter to make this possible (#332).
  • postgresql_set - avoid postgres puts extra quotes when passing values containing commas (#78).
  • postgresql_user - make the module idempotent when password is scram hashed (#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 (#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 (#277).
  • postgresql_pg_hba - add argument overwrite (bool, default: false) to remove unmanaged rules (#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 (#297).
  • postgresql_pg_hba - add argument rules to specify a list of rules using the normal rule-specific argument in each item (#297).

Bugfixes

  • Include simplified_bsd.txt license file for various module utils.
  • postgresql_info - fix pg version parsing (#315).
  • postgresql_ping - fix pg version parsing (#315).
  • postgresql_privs.py - add functionality when the PostgreSQL version is 9.0.0 or greater to incorporate ALL x IN SCHEMA syntax (#282). Please see the official documentation for details regarding grants (https://www.postgresql.org/docs/9.0/sql-grant.html).
  • postgresql_subscription - fix idempotence by casting the connparams dict variable (#280).
  • postgresql_user - add alter user-statements in the return value queries (#307).

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 (#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 (#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 (#212).

Bugfixes

  • postgresql_db - get rid of the deprecated psycopg2 connection alias database in favor of dbname when psycopg2 is 2.7+ is used (#194, #196).

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 (#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+ (#196).
  • postgresql_query - cannot handle .sql file with \n at end of file (#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 (#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 (#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 (#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 (#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 (#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

  • postgresql_db - Add the force boolean option to drop active connections first and then remove the database (#109).
  • postgresql_info - Add the raw return value for extension version (#138).
  • postgresql_pg_hba - Add the parameters keep_comments_at_rules and comment (#134).

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

  • postgresql_db - add support for the directory format when the state option is dump or restore (#108).
  • postgresql_db - add the rename value to the state option (#107).

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 (#85).

Bugfixes

  • postgresql_privs - fix fail_on_role check (#82).

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 (#68).
  • postgresql_ping - add the patch, full, and raw values of the server_version return value (#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

  • postgresql_query - add a warning to set as_single_query option explicitly (#54).
  • postgresql_query - fix datetime.timedelta type handling (#47).
  • postgresql_query - fix decimal handling (#45).
  • postgresql_set - fails in check_mode on non-numeric values containing B (#48).

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 (#37).

Bugfixes

  • postgresql_info - fix crash caused by wrong PgSQL version parsing (#40).
  • postgresql_ping - fix crash caused by wrong PgSQL version parsing (#40).
  • postgresql_set - return a message instead of traceback when a passed parameter has not been found (#41).

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