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).

Click here to see records for 2022 - 2020

2022

TKU January 2022

In TKU January 2022, the Postgres Extended Discovery pattern was updated to prevent the creation of erroneous databases when the psql command returns no db credentials or no permission to run (DRDC1-17915).

2021

TKU October 2021

In TKU October 2021:

  • added a configuration option for active versioning. On by default.
  • log messages updated.

TKU September 2021

In TKU September 2021:

  • Added 'instance' attribute (DRDC1-16691).
  • pattern trigger updated.

TKU August 2021

In TKU August 2021 updated WMI versions mapping (DRDC1-16928).

TKU February 2021

In TKU February 2021 added a check for the localhost bind_adress (127.0.0.0/8) and updated package versioning (DRDC1-16403).

TKU January 2021

In TKU January 2021 updated approach to get 'bind_address' attribute (DRDC1-16224).

2020

TKU November 2020

In TKU November 2020:

  • Updated active versioning (DRDC1-15915).
  • Added file versioning for Fujitsu Enterprise Postgres (DRDC1-15915).
  • Updated approach to get listening IP (DRDC1-15900).

TKU September 2020

In TKU September 2020 added cluster support (DRDC1-15463).

TKU July 2020

In TKU July 2020 added Fujitsu publisher (DRDC1-15164).

TKU April 2020

In TKU April 2020 was removed trailing directory separator in data_dir (DRDC1-14655).

TKU January 2020

In TKU January 2020 was updated regex to extract bind address (DRDC1-14352).

Click here to see records for 2019 - 2009

2019

TKU September 2019

In TKU September 2019 additional attributes are visible on PostgreSQL.

TKU July 2019

In TKU July 2019 the following changes were made:

  • Added port extraction approach from args on Windows (DRDC1-13252).

TKU May 2019

In TKU May 2019 added correct publisher and product attributes to SI (DRDC1-13161).

TKU April 2019

In TKU April 2019 the following changes were made:

  • Pattern runCommands updated.

2018

TKU December 2018

In TKU December 2018 added a check for the case when bind_adress = 127.0.0.1 (DRDC1-12384).

TKU November 2018

In TKU November 2018 the following updates were implemented:

  • Added bind_adress to the PostgreSQL Server name to make it more unique. (DRDC1-12238).
  • Added a check for the case when bind_adress = localhost (DRDC1-12297).

TKU October 2018

In TKU October 2018 the following updates were implemented:

  • we added  '<bin_dir>/psql -p <port> -t -l ' command to PostgreSQL RDBMS - Database Detail Pattern to retrieve DB list.(|DRDC1-11833).
  • bind_address extraction approach was added. Now the pattern takes the value from postgresql.conf file. (DRDC1-11560).
  • data_path value was added into the SI key to split DB Servers running on the same host and have identical ports. (DRDC1-11560).

TKU September 2018

In TKU September 2018 we improved package versioning.

TKU August 2018

In TKU August 2018 we updated regex for port attribute extraction to avoid Database Server SIs fusion. (DRDC1-11794).

TKU June 2018

In TKU June 2018 the pattern was updated to model additional attributes for the Software Instance:

  • conf_dir (DRDC1-11434).
  • bind_address (DRDC1-11453).

2017

TKU November 2017

In TKU November 2017 support for Infobright database was added. (DRDC1-8026).

TKU March 2017

In TKU March 2017 support for EnterpriseDB Postgres Advanced Server was added into the pattern module.

Added support for installation on IBM PowerHA Cluster(DRDC1-7514).

2016

TKU June 2016

In TKU June 2016 the trigger process was updated.

2014

TKU August 2014

In TKU August 2014, the pattern was updated to model additional attributes for the Software Instance:

  • short_name (TKU-2353).
  • listening_ports (TKU-2355).

2012

TKU February 2012

In TKU February 2012 updated pattern to add attributes for PostgreSQL 'bin' and 'data' directories.

2011

TKU December 2011

In TKU December 2011 updated pattern to add code to obtain port and version information from file if not obtained from the existing methods

2009

TKU December 2009

In TKU September 2009 updated trigger process for version 8.2, Port attribute is set as a string value.

TKU October 2009

In TKU October 2009 updates for CDM mapping.

TKU January 2009

In TKU January 2009 module name changed so that the module namespace is extended.

For more information about changes since the previous release, see BMC Discovery TKU Archive.

Go Back To Product Page

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*