Backup and Restore DB

[aprilrieger]

Related EPIC Ticket Ref: #70

Dependent on: Deployment of the updated/final production-deploy.yaml file, ticket:

Goal: back up the existing db in r2-pals cluster and restore it in the r2-besties cluster

backup/restore sql db dump

Documentation how to do it: https://www.postgresql.org/docs/11/backup-dump.html
Where to find the current db to sql dump: https://r.notch8.cloud/dashboard/c/c-sdwjk/explorer/apps.statefulset/production-arce/production-postgresql

psql -U postgres -W
**Will prompt for the password
Where to find pw: # insert 1pass link
Add more April

Any additional info someone would need to do this task?