> For the complete documentation index, see [llms.txt](https://ibm-developer.gitbook.io/digital-developer-conference-hybrid-cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ibm-developer.gitbook.io/digital-developer-conference-hybrid-cloud/microservice-workshop-oss/oss/pg_full.md).

# Database setup

Use the IBM Cloud console to launch the OpenShift web console

![web console](/files/-MHWIeLpIf5GhiclvCJc)

First create an 'Example Bank' namespace

![create project](/files/-MHWIeLqaQRezFn2xVAI)

From the navigation menu on the left select **Operators** --> **OperatorHub**

![operatorhub](/files/-MHWIeLrBaDamIwCwHCD)

Type 'Postgres' into the search bar, and select the **PostgreSQL Operator by Dev4Ddevs.com** tile.

![postgres operator](/files/-MHWIeLsZxP3CmG6auDx)

Click **Continue** to show the community operator and then **Install**

![install operator](/files/-MHWIeLtbvymfZ_1Vjxk)

Be sure you are installing the Operator in the `Example Bank` namespace, and click **Subscribe**

![subscribe](/files/-MHWIeLvs3FXj0xGJiza)

Status will show "Succeeded: Up to date" when complete

![succeeded](/files/-MHWIeLvs3FXj0xGJiza)

Use the very top drop down in the navigation menu on the left to switch to *Developer\** view

![developer view](/files/-MHWIgi1pkaPakGkc4LI)

Click **+Add** and select the Database tile

![add database](/files/-MHWIgi5_74BcwSATyk-)

Choose the **Database Database** tile and then **Create**

![database](/files/-MHWIgi6TlsUuGEyYmcx)

You can edit some of the specifics of the database here. For example, change the name to `creditdb` and click **Create**

![create database](/files/-MHWIgi7n7eWV2Ts9sgH)

Switch to the Topology tab, and watch your database creation complete!

![topology](/files/-MHWIgi8qlXmywyng2Yd) Use the very top drop down in the navigation menu on the left to switch to *Developer\** view

![developer view](/files/-MHWIgi1pkaPakGkc4LI)

Click **+Add** and select the Database tile

![add database](/files/-MHWIgi5_74BcwSATyk-)

Choose the **Database Database** tile and then **Create**

![database](/files/-MHWIgi6TlsUuGEyYmcx)

You can edit some of the specifics of the database here. For example, change the name to `creditdb` and click **Create**

![create database](/files/-MHWIgi7n7eWV2Ts9sgH)

Switch to the Topology tab, and watch your database creation complete!

![topology](/files/-MHWIgi8qlXmywyng2Yd)

Now we will need some CLI access. First, go to <https://labs.cognitiveclass.ai> and start a **Theia - Cloud IDE (With OpenShift)** session

![cognitiveclass](/files/-MHWIel18aFy0bnmJDw3)

back on your OpenShift web console, click you email address in the upper right corner and choose **Copy Login Command**

![copy login command](/files/-MJ7osSa1XHuwzr6HVyr)

From the resulting screen, grab your login credentials, and copy them into your ClognitiveClass terminal

![clusterlogin](/files/-MHWIel6qCBZXlB9EfhK)

switch to the example bank project:

```
oc project example-bank
```

Create a secret so the script that loads the schema can access the database

```
kubectl create secret generic bank-db-secret --from-literal=DB_SERVERNAME=creditdb --from-literal=DB_PORTNUMBER=5432 --from-literal=DB_DATABASENAME=example --from-literal=DB_USER=postgres --from-literal=DB_PASSWORD=postgres
```

Run the job to create the schema

```
oc apply -f data_model/job.yaml
```

![schema](https://raw.githubusercontent.com/IBM/example-bank/main/images/schema-1.png)

Verify that the schema load succeeded:

```
oc logs cc-schema-load-<pod>
```

Now that the database is ready, we can build and deploy the remaining microservices.