Openshift - bcgov/BCAT GitHub Wiki

We take dev as example in the following:

1. install oc-cli brew install openshift-cli

2. login to openshift

• copy and paste to your terminal

3. port-forwarding from local to openshift db oc -n <name_space> port-forward <pod_name> <local port>:5432

EX: oc -n bfe2da-dev port-forward bcat-db-dev-2-ks9gk 6432:5432

4. now you can connect to openshift db with port: 6432 locally

• grab the db creds from secrets

• dbeaver (optional)

5. dump db pg_dump -U trdbbcatd -h localhost -p 6432 -x -s -Fc bcat > dump.dump

6. restore db locally pg_restore -h localhost -U db2inst1 --no-owner --role=db2inst1 -v -e -c -C -d template1 dump.dump