Search <book_title>...

NetBackup™ Deployment Guide for Kubernetes Clusters

Last Published: 2025-02-26

Product(s): NetBackup & Alta Data Protection (10.5.0.1)

Upgrade PostgreSQL database

Perform the following steps when installing/upgrading the PostgreSQL database.

Use the following command to save the PostgreSQL chart values to a file:
helm show values postgresql-<version>.tgz > postgres-values.yaml

Use the following command to edit the chart values:

logDestination: stderr

vi postgres-values.yaml

Following is an example for postgres-values.yaml file:

# Default values for postgresql.
global:
  environmentNamespace: "netbackup"
  containerRegistry: "<EKS Container Registry Name>"
  timezone: null
 
postgresql:
  replicas: 1
  # The values in the image (name, tag) are placeholders. These will be set
  # when the deploy_nb_cloudscale.sh runs.
  image:
    name: "netbackup/postgresql"
    tag: "16.3-0036"
    pullPolicy: Always
  service:
    serviceName: nb-postgresql
  volume:
    volumeClaimName: nb-psql-pvc
    volumeDefaultMode: 0640
    pvcStorage: 30Gi
    # configMapName: nbpsqlconf
    storageClassName: nb-disk-premium
    mountPathData: /netbackup/postgresqldb
    secretMountPath: /netbackup/postgresql/keys/server
    # mountConf: /netbackup
  securityContext:
    runAsUser: 0
  createCerts: true
  # pgbouncerIniPath: /netbackup/pgbouncer.ini
  nodeSelector:
    key: agentpool
    value: nbupool
 
  # Resource requests (minima) and limits (maxima). Requests are used to fit
  # the database pod onto a node that has sufficient room. Limits are used to
  # throttle (for CPU) or terminate (for memory) containers that exceed the
  # limit. For details, refer to Kubernetes documentation:
  # https://kubernetes.io/docs/concepts/configuration/manage-resources-containers/#resource-units-in-kubernetes
  # Other types of resources are documented, but only `memory` and `cpu` are
  # recognized by NetBackup.
  #
  # resources:
  #   requests:
  #     memory: 2Gi
  #     cpu: 500m
  #   limits:
  #     memory: 3Gi
  #     cpu: 3
 
  # Example tolerations. Check taints on the desired nodes and update keys and
  # values.
  #
  tolerations:
  - key: agentpool
    value: nbupool
  - key: agentpool
    value: mediapool
  - key: agentpool
    value: primarypool
  - key: storage-pool
    value: storagepool
  - key: data-plane-pool
    value: dataplanepool
  serverSecretName: postgresql-server-crt
  clientSecretName: postgresql-client-crt
  dbSecretName: dbsecret
  dbPort: 13785
  pgbouncerPort: 13787
  dbAdminName: postgres
  initialDbAdminPassword: postgres
  dataDir: /netbackup/postgresqldb
  # postgresqlConfFilePath: /netbackup/postgresql.conf
  # pgHbaConfFilePath: /netbackup/pg_hba.conf
  defaultPostgresqlHostName: nb-postgresql
 
  # file   => log postgresdb in file the default
  # stderr => log postgresdb in stderr so that fluentbit daemonset collect the logs.
  logDestination: file
 
postgresqlUpgrade:
  replicas: 1
  image:
    name: "netbackup/postgresql-upgrade"
    tag: "16.3-0036"
    pullPolicy: Always
  volume:
    volumeClaimName: nb-psql-pvc
    mountPathData: /netbackup/postgresqldb
    timezone: null
  securityContext:
    runAsUser: 0
  env:
    dataDir: /netbackup/postgresqldb
To save $$ you can set storageClassName to nb-disk-standardssd for non-production environments.

Execute the following command to upgrade the PostgreSQL database:
helm upgrade --install postgresql postgresql-<version>.tgz -f postgres-values.yaml -n netbackup
Or
If using the OCI container registry, use the following command:
helm upgrade --install postgresql oci://abcd.veritas.com:5000/helm-charts/netbackup-postgresql --version <version> -f postgres-values.yaml -n netbackup

Taints and tolerations

If primary node pool has taints applied and they are not added to postgres-values.yaml file, then manually add tolerations to the PostgreSQL StatefulSet as follows:

To verify that node pools use taints, run the following command:
kubectl get nodes -o=custom-columns=NodeName:.metadata.name,TaintKey:.spec.taints[*].key,TaintValue:.spec.taints[*].value,TaintEffect:.spec.taints[*].effect
```
NodeName TaintKey TaintValue TaintEffect
ip-10-248-231-149.ec2.internal <none> <none> <none>
ip-10-248-231-245.ec2.internal <none> <none> <none>
ip-10-248-91-105.ec2.internal nbupool agentpool NoSchedule
```
To view StatefulSets, run the following command:
kubectl get statefulsets -n netbackup
```
NAME READY AGE
nb-postgresql 1/1 76m
nb-primary 0/1 51m
```
Edit the PostgreSQL StatefulSets and add tolerations as follows:
kubectl edit statefulset nb-postgresql -n netbackup

Following is an example of the modified PostgreSQL StatefulSets:

apiVersion: apps/v1
kind: StatefulSet
metadata:
  annotations:
    meta.helm.sh/release-name: postgresql
    meta.helm.sh/release-namespace: netbackup
  creationTimestamp: "2024-03-25T15:11:59Z"
  generation: 1
  labels:
    app: nb-postgresql
    app.kubernetes.io/managed-by: Helm
  name: nb-postgresql
...
spec:
  template:
    spec:
      containers:
      ...
 
 
      nodeSelector:
        nbupool: agentool
      tolerations:
      - effect: NoSchedule
        key: nbupool
        operator: Equal
        value: agentpool