Create staging database

On Prod

Backup prod database

• Login prod postgresql pod and run command "pg_dump tfrs | gzip > /postgresql-backup/SQLDump/prod/tfrs-[DateTime].gz"
• Copy the above database dump to local drive "oc rsync [pod name]:[path to the dump file] [local drive]"

On Test

Create the secret for staging database on test

• Create secret tfrs-postgresql-staging which contains same content as prod secret tfrs-postgresql

Create storage

• Create postgresql-staging-cns storage

Bring down the postgresql database

Create DC/postgresql-staging

• Create DC/postgresql-staging and mount postgresql-backup-cns to it
• Use the secret tfrs-postgresql-staging for environment variable

Copy the prod SQL Dump file to staging

• oc rsync [local drive] [pod name]:/postgresql-backup/SQLDump/prod

Verify Django migration table contents

• Test either has same release deployed as prod, or one or a couple ahead.
• If we don't run deployment on test, only duplicate prod database to test, there should be no migration happening.
• Further verification may be needed.

Run following command to restore staging database from prod dump file

• psql tfrs
• #DROP SCHEMA public CASCADE;
• #CREATE SCHEMA public;
• #GRANT ALL ON SCHEMA public TO postgres;
• #GRANT ALL ON SCHEMA public TO public;
• quit psql
• run command 'gunzip -c /postgresql-backup/SQLDump/prod/tfrs-[DateTime].gz | psql tfrs'

Update the selector of postgresql service to choose postgresql-staging

Update the DATABASE_USER and DATABASE_PASSWORD in tfrs DC Environment to use tfrs-postgresql-staging secret