Value Statement

This requirement is from Insights on Prem. 

rhn-engineering-jharting we are consolidating the database version in use on pg16 https://issues.redhat.com/browse/RHCLOUD-35581 so that services can share the same database. We'd like to use the MCGH-provided database

Goal: 

Enable postgres 16 to meet IoP requirements. for the longer term, we may leverage Crunchy Operator for postgres support.

the image is available - https://catalog.redhat.com/software/containers/rhel9/postgresql-16/657b03866783e1b1fb87e142?gs&q=postgres 

Definition of Done for Engineering Story Owner (Checklist)

• Support configuring the version of postgres in MGH CR. default is postgres 13.
• The built-in PostgreSQL StatefulSet will be renamed from multicluster-global-hub-postgres to multicluster-global-hub-postgresql.
• Operand: mgh- component - from multicluster-global-hub-postgres to multicluster-global-hub-postgresql
• Naming for Postgres svc, secret

Development Complete

• The code is complete.
• Functionality is working.
• Any required downstream Docker file changes are made.

Tests Automated

• [x] Unit/function tests have been automated and incorporated into the
  build.
• [x] 100% automated unit/function test coverage for new or changed APIs.

Secure Design

• [n/a] Security has been assessed and incorporated into your threat model.

Multidisciplinary Teams Readiness

• [n/a] Create an informative documentation issue using the [Customer
  Portal_doc_issue template](
  https://github.com/stolostron/backlog/issues/new?assignees=&labels=squad%3Adoc&template=doc_issue.md&title=),
  and ensure doc acceptance criteria is met. Link the development issue to
  the doc issue.
• [n/a] Provide input to the QE team, and ensure QE acceptance criteria
  (established between story owner and QE focal) are met.

Support Readiness

• [n/a] The must-gather script has been updated.