Enabling external access to the internal PostgreSQL database

If you plan to install DevOps Plan using the internal PostgreSQL database and need to access it through the DevOps Plan Designer or other supports PostgreSQL tools, such as pgAdmin 4, you must enable external PostgreSQL access in the helm install or helm upgrade command.

Procedure

  1. Enable PostgreSQL access in the helm install or helm upgrade command. 
    --set postgresql.enableExternalAccess=true
  2. After enabling this setting, run the helm status command to view the configuration values that are required for connecting to the PostgreSQL database.
    Host
    Use global.domain if installing on an OpenShift cluster or using an Emissary-ingress Load Balancer.
    Use the VM IP address if installing on a local Kubernetes cluster.
    Port
    Use the value of postgresql.externalAccessPort. The default value is 30106.
    Database
    postgres
    Username
    postgres
    Password
    To retrieve the password, run the following command, ensuring that the namespace is set to devopsplan.
    kubectl get secret --namespace devopsplan devopsplan-postgresql -o jsonpath="{.data.tenant-datastore-password}" | base64 -d; echo