Creating a service instance for EDB Postgres from the web client

To create a service instance:

1. From the Cloud Pak for Data services catalog, select EDB Postgres.
2. Click New Instance.
3. Enter a name for the instance and then select the namespace where you want to deploy the database.
   Click Next.
4. Specify the following options for EDB Postgres on the OpenShift® Container Platform cluster:
   • Number of nodes. Use this option to specify the number of EDB Postgres database instances you want to deploy.
   • Cores per node
   • Memory per node. You can allocate a minimum of 4 GiB of memory per database instance.
   • Version
   • Custom TLS Server Cert Secret and Custom TLS Client Cert Secret. If you generate custom TLS server and client certificates, use these options to set the respective secrets.
     The EDB Postgres database provides self-signed TLS certificates by default. If you want to use your own custom client and server TLS certificates, make sure that the generated secrets contain the following parameters:

     • ca.crt
     • tls.crt
     • tls.key
   • Type. Depending on the EDB Postgres distribution you use, set the type to Standard or Enterprise. Use the Add custom credentials (Optional) option to set a custom username and password to access your database instance. For more information, see Creating a custom EDB Postgres user name and password.
5. From the storage classes that are available on the cluster, specify the size and unit for the storage class. For a list of the storage classes that are compatible with EDB Postgres, see EDB Postgres storage requirements.
   Click Next.
6. Confirm the information provided on the review page.
   Click Create. It might take up to five minutes for the instance to be ready.
7. Run the following command to check the status of the instance:

   oc describe CPDEdbInstance <EDBInstanceName> -n ${PROJECT_CPD_INST_OPERANDS}

   where the namespace is the OpenShift operands project where Cloud Pak for Data is installed.

   The status result will be similar to the following example:

   Status:
   Conditions:
   Last Transition Time: 2021-06-14T17:41:38Z
   Message:              Running reconciliation
   Reason:               Running
   Status:               True
   Type:                 Running
   Edb Status:           In Progress

   The instance is ready for use when Edb Status changes from In Progress to Completed.