-
Notifications
You must be signed in to change notification settings - Fork 36
Update PostGres Oracle Foreign Data Wrapper image
The base image for our PostGres deployments is at: https://github.com/bcgov/openshift-postgresql-oracle_fdw
To update the image (e.g. update postgres startup parameters or perhaps new version of underlying software), update the GitHub repo and rebuild the openshift-postgresql-oracle-fdw
image via the console.
After the successful build, we need to redeploy to each environment (moe-gwells-dev Note that each environment is distinctly tagged as either :dev, :test: or :prod; to actually redeploy using the new (:latest) image, you must tag the image.
oc project moe-gwells-tools
oc get istag | grep openshift-postgresql-oracle-fdw
Confirm that the SHA #'s are as expected (i.e. :latest is different from the others), and then tag the :dev image first:
oc tag openshift-postgresql-oracle-fdw:latest openshift-postgresql-oracle-fdw:dev
oc get istag | grep openshift-postgresql-oracle-fdw
Confirm that the SHA #'s are as expected (i.e. :dev is the same as :latest), and then monitor the auto-deploy on the console.
After the successful re-deploy, we need to repeat for :test.
oc tag openshift-postgresql-oracle-fdw:latest openshift-postgresql-oracle-fdw:test
oc get istag | grep openshift-postgresql-oracle-fdw
Confirm that the SHA #'s are as expected (i.e. :test is the same as :latest), and then monitor the auto-deploy on the console.
After the successful re-deploy, we need to repeat for :prod.
oc tag openshift-postgresql-oracle-fdw:latest openshift-postgresql-oracle-prod
oc get istag | grep openshift-postgresql-oracle-fdw
NOTE: There are additional details at the BCDevOps/openshift-wiki.
- Working on GWELLS (full workflow from writing code to deploying to prod)
- Water terminologies
- Testing
- Swagger Documentation
- Restore a database backup manually
- (Archived) Manual Syncing of DEV to TEST to PROD
- (Archived) Setup GWells data migration for local dev test
- Update PostGres Oracle Foreign Data Wrapper image
- Increase PostgreSQL Database storage
- (Archived) Regular Corruption of the PostgreSQL DB
- (Archived) Recovering from a corrupt PostgreSQL Database