debug-pg

Related Issues

• Huge Pages Postgres Issues
  • see workaround with config map for init
    • extraVolumenMounts has moved to primary.extraVolumeMounts
    • works so far as /opt/bitnami/postgresql/share/postgresql.conf.sample is set to config map values
  * echo 4 | sudo tee /sys/kernel/mm/hugepages/hugepages-2048kB/nr_hugepages and lower values work
  • echo 8 | sudo tee /sys/kernel/mm/hugepages/hugepages-2048kB/nr_hugepages and higher values break
• similar bug in some zalando project
  • solution here, disable huge pages in postgresql.conf.same with postgresql.conf.sample: "huge_pages = off" (path doesn’t work with bitnami chart)
• potential solutions
• similar, same issue on OpenShift
• Same issue for docker-library

Chart

• default values

Postgres

• “The Postgresql documentation is not clear about it, but initdb apparently uses postgresql.conf.sample and not postgresq.conf.”

Hugepages

• Debian
• Needed for DBs

Debug

• --set image.debug=true enables debug logging for bitnami charts
• --set diagnosticMode.enabled=true start container with sleep and no healthchecks, perfect for exec’ing into the pod
• kubectl describe pod test-postgresql-0 -n pg shows more details

Files

Mounting config files doesn’t work

works fine for postgresql.conf.sample, but postgresql.conf is an empty directory

apiVersion: v1
kind: ConfigMap
metadata:
  name: pg-sample-config-init
data:
  postgresql.conf.sample: |-
   huge_pages = off
   

apiVersion: v1
kind: ConfigMap
metadata:
  name: pg-sample-conf
data:
  postgresql.conf: |-
   huge_pages = off
   

values.yaml:

primary:
  extraVolumeMounts:
          - name: pg-sample-config-init
            mountPath: /opt/bitnami/postgresql/share/postgresql.conf.sample
            subPath: postgresql.conf.sample
          - name: pg-sample-config
            mountPath: /opt/bitnami/postgresql/share/postgresql.conf
            subPath: postgresql.conf
  extraVolumes:
          - configMap:
              name: pg-sample-config-init
            name:  pg-sample-config-init
          - configMap:
              name: pg-sample-config
            name:  pg-sample-config