Skip to content

Latest commit

 

History

History
686 lines (477 loc) · 32.6 KB

CHANGELOG.rst

File metadata and controls

686 lines (477 loc) · 32.6 KB
Raw

Community PostgreSQL Collection Release Notes

Topics

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 (ansible-collections#744).
  • postgresql_set - forbids resetting shared_preload_libraries by passing an empty string (ansible-collections#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

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 (ansible-collections#724).
  • postgresql_subscription - adds support for managing subscriptions in the situation where the subconninfo column is unavailable (such as in CloudSQL) (ansible-collections#726).

Bugfixes

  • postgresql_db - fix issues due to columns in pg_database changing in Postgres 17. (ansible-collections#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 (ansible-collections#714).
  • postgresql_publication - add the tables_in_schema argument to implement FOR TABLES IN SCHEMA feature (ansible-collections#709).
  • postgresql_user - adds the configuration argument that allows to manage user-specific default configuration (ansible-collections#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 (ansible-collections#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 (ansible-collections#594).
  • postgresql_ext - Reconnect before upgrade to avoid accidental load of the upgraded extension (ansible-collections#689).
  • postgresql_idx - consider schema name when checking for index (ansible-collections#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 (ansible-collections#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

Bugfixes

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

Bugfixes

  • postgresql_query - now reports not changed for queries starting with "SHOW" (ansible-collections#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. (ansible-collections#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

Bugfixes

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 (ansible-collections#556).

Minor Changes

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 (ansible-collections#559).

Bugfixes

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 extension 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