Table of contents

Creating a database deployment on the cluster (EDB Postgres)

You create a database deployment on your cluster from the IBM® Cloud Pak for Data web client.

Before you begin

Ensure that you have completed the steps in the previous install topics before proceeding.

About this task

You must have the Create service instances permission to complete this task.

Tip: If you are deploying a sandbox environment, you can use the Create with defaults option to deploy the database. However, you don't have any control over the resources that are allocated to the database, the storage that is used, and so forth.

Procedure

  1. From the navigation, select Data > Databases.
  2. Click Create a database.
  3. Select the database type and version. Click Next.
  4. Specify the number of cores to use.

    You are constrained by the total number of cores on the node. For example, if you created a node with 16 cores, you can specify up to 16 cores (the allocation that is needed by the cluster operational services). If the database is deployed on multiple nodes, the resources must exist on each node.

  5. Specify the amount of memory to use.

    You are constrained by the total amount of memory on the node. For example, if you created a node with 512 GB of memory, you can specify up to 512 GB (the amount that is needed by the cluster operational services). If the database is deployed on multiple nodes, the resources must exist on each node.

  6. Specify storage locations.
    EDB Postgres requires a dynamic storage class for your user data (the main database data). Specify a storage volume type, a name, and a size for the storage location.
    Storage type Details
    • Portworx (required storage class: portworx-db-gp)
    • ocs-storagecluster-ceph-rbd (required storage class: ocs-storagecluster-rdb)

    Select a storage class from the storage class drop down for user storage (database data).

  7. Click Next.
  8. Optional: Specify a new display name for the database.
  9. Ensure that the summary is correct and click Create.

    The database is ready when it shows up as Available on the Databases tab.