PostgreSQL RDBMS - Change History
2025
TKU May 2025
In TKU May 2025 we improved:
- How we find adminuser
- How we run pg_dumpall and psql, we now add a -w option so the command never hangs if the system prompts for a password
- How we run psql with UNIX privileged execution
- How we handle instances where the path to the trigger process is not fully qualified.
- How we handle package versioning
TKU February 2025
In TKU February 2025 we improved how the pattern finds port information. We also updated the key for newly created SoftwareInstances. The key will not change for SoftwareInstances created before TKU February 2025
2024
TKU February 2024
Updated the getState() function to provide the command with the restrict_paths parameter.
TKU June 2024
In TKU June 2024 we changed both the main pattern and the database detail pattern.
- In the main pattern we improved the robustness of the code to find postgres_data_path, the path to postgresql.conf and port
- In the database detail pattern we added a fix regarding how the admin user specified in the configuration block of the pattern is passed to the pg_dumpall command.
2023
TKU December 2023
In TKU December 2023 we removed reference to SoftwareClusters. According to the publisher, PostgreSQL considers a cluster to be “a collection of databases that is managed by a single instance of a running database server”. This is different to the Discovery definition of "a group of hosts collaborating"
Removing reference to clusters means the SoftwareInstance has a changed key
We also fixed the database query used to find database state
TKU October 2023
In TKU October 2023 we added a state attribute to the SoftwareInstance. This can have value production or standby
TKU April 2023
In TKU April 2023 we improved the cluster model. It now handles situations where hosts are in different scopes.
TKU January 2023
In TKU January 2023, the Postgres Extended Discovery pattern was updated with a fix for potential Enterprise DB SQL queries not working as expected (DRDC1-20421).
For more information about changes since the previous release, see BMC Discovery TKU Archive.