Upgrade Postgres 14 upgrade

[patriciarussellCAS]

Describe the task

From Platform Services: The current version of the Crunchy operator is the last version with Postgres 14 compatibility. The operator will need to be upgraded in preparation for the next OpenShift upgrade, but the operator cannot be upgraded until all Crunchy databases are at Postgres 15 or higher.

Most of you should be able to follow the instructions found here in order to perform an in-place upgrade: https://access.crunchydata.com/documentation/postgres-operator/5.5/guides/major-postgres-version-upgrade.

the following is a list of the currently available Postgres and PostGIS versions and images, for your reference so you know what upgrade paths are available to you:

• postgresVersion: 14

postGISVersion: 3.1

postGISVersion: 3.2

postGISVersion: 3.3

• postgresVersion: 15

postGISVersion: 3.3

• postgresVersion: 16

postGISVersion: 3.3

postGISVersion: 3.4

Acceptance Criteria

• [ ] Migration procedure documented, using https://access.crunchydata.com/documentation/postgres-operator/latest/guides/major-postgres-version-upgrade
• [ ] CIF-dev migrated to pg16
• [ ] CIF-test migrated to pg16
• [ ] CIF-prod migrated to pg16
• [ ] BCIERS-reg1-dev migrated to pg16
• [ ] BCIERS-reg1-test migrated to pg16
• [ ] BCIERS-reg1-prod migrated to pg16
• [ ] BCIERS-dev migrated to pg16
• [ ] BCIERS-test migrated to pg16
• [ ] BCIERS-prod migrated to pg16

Definition of Done

• [ ] first
• [ ] second
• [ ] third

Additional context

• Add any other context about the task here.
• Or here

[patriciarussellCAS]

@dleard and @pbastia - here's the ticket for the postgres update.