Configuring external access to the Plan PostgreSQL database

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

About this task

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.

Procedure

  1. Use the following options with the Helm install or Helm Upgrade command:
    --set hcl-devopsplan-prod.postgresql.enableExternalAccess=true \
    --set hcl-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.

Results

You have configured external access to the Plan PostgreSQL database.

What to do next

You can view the connection details from the DevOps Plan UI. See Viewing connection details from the DevOps Plan UI.