Configuring external access to the Plan PostgreSQL database

You can configure external PostgreSQL access during installation by using a Helm upgrade.

When you install DevOps Loop by using the internal DevOps Plan PostgreSQL database and need to access it from DevOps Plan Designer or other supported PostgreSQL tools (such as pgAdmin 4), you must enable PostgreSQL access and configure the exposed port during installation or upgrade.
  1. Use the following options with the Helm install or Helm Upgrade command: 
    --set ibm-devopsplan-prod.postgresql.enableExternalAccess=true \
--set ibm-devopsplan-prod.postgresql.service.exportPort=30106
  2. Use the following details to connect to the PostgreSQL database:

    • Host: global.domain

    • Port: 30106

    • Database: postgres

    • Username: postgres

  3. Run the following command to retrieve the password: 
    kubectl get secret --namespace devops-loop devopsplan-postgresql \
-o jsonpath="{.data.tenant-datastore-password}" | base64 -d; echo
    Note: You must ensure the namespace is set to devops-loop.
You have configured external access to the Plan PostgreSQL database.
You can view the connection details from the DevOps Plan UI. See Viewing connection details from the DevOps Plan UI.