Upgrade prod db engine

[cnlucas]

What we're after:
Cloud.gov needs us to upgrade our CMS db instance from PG 11 to PG 12, as they are retiring PG 11.

Refer to Cloud.gov email for more information.

Completion criteria:

• We are upgraded to PG 12 15

Tech steps or considerations (optional)

• Confirm with cloud.gov our maintenance window by Feb 14th
• Upgrade the db instance by Feb 29th

[pkfec]

PostgreSQL database service in our lower environments is currently on version PG 15.x.

[pkfec]

Steps i followed to upgrade CMS postgres DB from PG 11 to PG 15 in Prod:

1. ssh into existing fec-cms-prod rds service
2. take pg_dump from fec-cms-prod service
3. create new service fec-cms-prod-new
4. SSH and restore cms pg dump on to the new fec-cms-prod-new service
5. connect and confirm the tables and data exist on the new DB instance (DBeaver or PGAdmin)
6. unbind cms app from existing fec-cms-prod service
7. rename existing service from fec-cms-prod to fec-cms-prod-old-20240214
8. bind cms app to the new service fec-cms-prod-new
9. rename new service from fec-cms-prod-new to fec-cms-prod (rename new service to match with the name given in manifest.yml file)
10. on circleci rerun the latest master build

[pkfec]

he CMS database was updated to PostgreSQL 15 yesterday evening, and the website appears to be functioning properly

[pkfec]

CMS database in Prod environment was updated to PostgreSQL 15 yesterday evening, and the website appears to be functioning properly