Datacube 1.9.0-rc5 pre-release

Datacube 1.9.0 release candidate 5

Another release candidate for the 1.9.0 release.

The 1.9.0 branch will remain in pre-release until we have working 1.9-compatible versions of the following key ODC packages: datacube-explorer, datacube-ows, eodatasets, and odc-apps-dc-tools. Work on migrating these packages is underway, and this pre-release
is mostly a response to that work - applying changes intended to ease 1.8.x to 1.9.x migration.

1.9.0-rc5 also (finally) adds support for product deletion - user requests for this feature date back to early 2017 - before the project had adopted the name "Open Data Cube" (ODC) and was still known as the Australian Geoscience Data Cube (AGDC).

Changes since 1.9.0-rc4

• Update whats_new.rst, ready for 1.9.0-rc5 release (#1594)
• Expand extra dimension support, WIP (#1593)
• Ensure pre-prepared EO3 datasets can be indexed. (i.e. ensure the prep_eo3() function is idempotent) (#1591)
• The canonical name of the postgres driver is now "postgres" with "default" as an alias instead of the other way around. (#1590)
• Update docker image to GDAL 3.9/Python 3.12/Ubuntu 24.04 (#1588)
• Fix typos in docs (#1577)
• Merge in recent 1.8.x branch changes. (#1568, #1579)
• Add Product delete methods to API and command in CLI, plus misc cleanup of the surrounds (#1583)

This pre-release includes contributions from @Ariana-B, @Kirill888, @pjonsson, and @SpacemanPaul