-
Notifications
You must be signed in to change notification settings - Fork 96
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Upgrade PostgreSQL Database (Major Version 12 Retirement) #4880
Comments
The current postgresql version is 15.7 if you run catalog-next is running on 15.7. So CKAN has no problem running on the latest RDS postgresql offered by cloud.gov. |
This should be a simple db dump of the old database (version 12.17) and then restore it to a new database (version 15.7). We have developed some automated scripts for db backup and restore. https://github.com/GSA/cf-backup-manager/tree/main/docs/backup_restore. Also there should be detailed steps in other tickets or slack discussion since we have done it multiple times. To verify things are working as expected, we can try the steps on catalog development and inventory development, after verification, then move on to staging and prod. Steps:
|
backup-manager is using pg 15.7 client in development
|
catalog development upgraded to v15
|
inventory staging upgraded to v15
|
Reid is facing few issues and debugging is in progress |
catalog staging upgraded to v15
|
PostgreSQL version 12 is scheduled for retirement in February 2025. We need to upgrade the database to a supported version before this deadline.
database services that need to be upgraded are:
The text was updated successfully, but these errors were encountered: