Chapter 8. Backup and disaster recovery

Procedure

1. Use the following SQL script to create user and database for the CodeReady Workspaces server to persist workspaces metadata etc:

   CREATE USER <database-user> WITH PASSWORD '<database-password>' 

   1

   2

   
   CREATE DATABASE <database>                                      

   3

   
   GRANT ALL PRIVILEGES ON DATABASE <database> TO <database-user>
   ALTER USER <database-user> WITH SUPERUSER

   Copy to Clipboard Toggle word wrap

   1

   CodeReady Workspaces server database username

   2

   CodeReady Workspaces server database password

   3

   CodeReady Workspaces server database name

2. Use the following SQL script to create database for RH-SSO back end to persist user information:

   CREATE USER <identity-database-user> WITH PASSWORD '<identity-database-password>' 

   1

   2

   
   CREATE DATABASE <identity-database>                                               

   3

   
   GRANT ALL PRIVILEGES ON DATABASE <identity-database> TO <identity-database-user>

   Copy to Clipboard Toggle word wrap

   1

   RH-SSO database username

   2

   RH-SSO database password

   3

   RH-SSO database name

Procedure

1. Pre-create a project for CodeReady Workspaces:

   $ oc create namespace workspaces

   Copy to Clipboard Toggle word wrap

2. Create a secret to store CodeReady Workspaces server database credentials:

   $ oc create secret generic <server-database-credentials> \ 

   1

   
   --from-literal=user=<database-user> \                            

   2

   
   --from-literal=password=<database-password> \                    

   3

   
   -n workspaces

   Copy to Clipboard Toggle word wrap

   1

   Secret name to store CodeReady Workspaces server database credentials

   2

   CodeReady Workspaces server database username

   3

   CodeReady Workspaces server database password

3. Create a secret to store RH-SSO database credentials:

   $ oc create secret generic <identity-database-credentials> \ 

   1

   
   --from-literal=user=<identity-database-user> \                     

   2

   
   --from-literal=password=<identity-database-password> \             

   3

   
   -n workspaces

   Copy to Clipboard Toggle word wrap

   1

   Secret name to store RH-SSO database credentials

   2

   RH-SSO database username

   3

   RH-SSO database password

4. To make the Operator skip deploying a database and pass connection details of an existing database to a CodeReady Workspaces server set the following values in the Custom Resource:

   spec:
     database:
       externalDb: true
       chePostgresHostName: <hostname>                     

   1

   
       chePostgresPort: <port>                             

   2

   
       chePostgresSecret: <server-database-credentials>    

   3

   
       chePostgresDb: <database>                           

   4

   
   spec:
     auth:
       identityProviderPostgresSecret: <identity-database-credentials> 

   5

   Copy to Clipboard Toggle word wrap

   1

   External database hostname

   2

   External database port

   3

   Secret name with CodeReady Workspaces server database credentials

   4

   CodeReady Workspaces server database username

   5

   Secret name with RH-SSO database credentials