Database Engine Version Upgrade

[r-bartlett-gsa]

As a challenge.gov stakeholder, in order to ensure minimum downtime and proper testing of the challenge.gov application after upgrade, I would like the upgrade done by challenge.gov team (rather than by cloud.gov).

Acceptance criteria:

• Create New RDS Instances:
  • Use the cg-manage-rds tool to create new RDS instances with PostgreSQL 15.
• Migrate Data:
  • Export data from the current PostgreSQL 12 databases:
    manage-rds export <instance-name>
  • Import the data into the new PostgreSQL 15 instances:
    manage-rds import <new-instance-name>
• Test Applications:
  • Update the application connection strings to point to the new database instances.
  • Perform functional and regression testing to ensure compatibility with PostgreSQL 15.
• Switch Production Databases:
  • After successful testing, finalize the data migration and promote the new database instance as the primary database for applications.
• Delete Old RDS Instances:
  • Once all applications are confirmed stable, delete the old PostgreSQL 12 instances:
    manage-rds delete <old-instance-name>

For additional information, see https://docs.google.com/document/d/10HZ3opqdeYveKllbCciN6Jhdwf5Qs3NGaxOkY9EHJZQ/edit?usp=drive_link
#1438

[r-bartlett-gsa]

@kkrug Just a reminder that this upgrade needs to be completed in January.

[kkrug]

@r-bartlett-gsa @TCKapGrp I put this in testing if you wanted to do any quick regression testing to make sure the new DB are good