postgresql helm release

No introduction found. Create it?

Name	Repo	Stars	Version	Timestamp
postgresql	axeII/home-ops	38	15.2.5	3 months ago
postgresql	jr0dd/home-ops	46	13.2.25	7 months ago

Name

Repo

Stars

Version

Timestamp

postgresql

axeII/home-ops

15.2.5

3 months ago

postgresql

jr0dd/home-ops

13.2.25

7 months ago

Key	Types
primary.persistence.enabled (13) `true`	boolean
primary.persistence.existingClaim (13) `postgresql-data`	string
primary.persistence.labels."recurring-job-group.longhorn.io/backup" (1) `enabled`	string
primary.persistence.size (1) `10Gi`	string
primary.persistence.storageClass (1) `longhorn`	string
primary.persistence.subPath (1) `postgresql`	string
primary.service.type (4) `LoadBalancer`	string
primary.service.loadBalancerIP (3) `${SVC_POSTGRESQL_ADDR}`	string
primary.service.annotations."external-dns.alpha.kubernetes.io/hostname" (1) `{{ .Release.Name }}.${SECRET_DOMAIN}`	string
primary.service.annotations."io.cilium/lb-ipam-ips" (1) `192.168.2.49`	string
primary.service.annotations."tailscale.com/expose" (1) `true`	string
primary.service.externalTrafficPolicy (1) `Cluster`	string
primary.resources.limits.memory (2) `226M`	string
primary.resources.requests.cpu (2) `15m`	string
primary.resources.requests.memory (2) `226M`	string
primary.containerSecurityContext.enabled (1) `true`	boolean
primary.containerSecurityContext.runAsNonRoot (1) `true`	boolean
primary.containerSecurityContext.runAsUser (1) `${PUID}`	string
primary.extraEnvVars[].name (1) `TZ`	string
primary.extraEnvVars[].value (1) `${TIMEZONE}`	string
primary.initdb.scriptsSecret (1) `postgresql-init`	string
primary.nodeSelector."kubernetes.io/hostname" (1) `eagle.home`	string
primary.pdb.create (1) `true`	boolean
primary.pdb.minAvailable (1) `1`	number
primary.podSecurityContext.enabled (1) `true`	boolean
primary.podSecurityContext.fsGroup (1) `${PGID}`	string
image.tag (11) `15.5.0`	string
image.repository (10) `bitnami/postgresql`	string
image.registry (5) `docker.io`	string
image.pullPolicy (1) `IfNotPresent`	string
metrics.enabled (7) `true`	boolean
metrics.serviceMonitor.enabled (7) `true`	boolean
metrics.serviceMonitor.interval (1) `1m`	string
metrics.prometheusRule.enabled (2) `true`	boolean
global.postgresql.auth.postgresPassword (6) `${SECRET_POSTGRES_PASSWORD}`	string
global.postgresql.auth.database (3) `wyoa`	string
global.postgresql.auth.existingSecret (2) `main-postgresql-secret`	string
global.postgresql.auth.password (2) `${POSTGRES_PASSWORD}`	string
global.postgresql.auth.username (2) `j_r0dd`	string
auth.enablePostgresUser (5) `true`	boolean
auth.postgresPassword (4) `${SECRET_POSTGRES_ADMIN_PASS}`	string
auth.database (3) `postgres`	string
auth.existingSecret (3) `pgsql-user-secret`	string
auth.secretKeys.adminPasswordKey (2) `postgres-password`	string
auth.usePasswordFiles (2) `false`	boolean
auth.username (1) `mb-scheduler`	string
audit.logTimezone (3)	string
audit.clientMinMessages (2) `error`	string
audit.containerSecurityContext.enabled (2) `true`	boolean
audit.containerSecurityContext.runAsUser (2) `1001`	number
audit.logConnections (2) `false`	boolean
audit.logDisconnections (2) `false`	boolean
audit.logHostname (2) `false`	boolean
audit.logLinePrefix (2)	string
audit.persistence.accessModes[] (2) `- ReadWriteOnce`	string
audit.persistence.enabled (2) `true`	boolean
audit.persistence.existingClaim (2)	string
audit.persistence.mountPath (2) `/bitnami/postgresql`	string
audit.persistence.size (2) `8Gi`	string
audit.persistence.storageClass (2)	string
audit.persistence.subPath (2)	string
audit.pgAuditLog (2)	string
audit.pgAuditLogCatalog (2) `off`	string
audit.updateStrategy.type (2) `RollingUpdate`	string
backup.enabled (3) `true`	boolean
backup.cronjob.schedule (2) `@daily`	string
backup.cronjob.storage.existingClaim (2) `postgresql-backups-v1`	string
backup.cronjob.storage.size (1) `8Gi`	string
backup.cronjob.storage.storageClass (1) `longhorn`	string
backup.cronjob.command[] (1) - /bin/sh - -c - BACKUP_DIR="$PGDUMP_DIR" BACKUPS_TO_KEEP=7 echo "Current backups in $BACKUP_DIR:" ls -lh $BACKUP_DIR/pg_dumpall-.pgdump pg_dumpall --clean --if-exists --load-via-partition-root --quote-all-identifiers --no-password --file=$BACKUP_DIR/pg_dumpall-$(date '+%Y-%m-%d-%H-%M').pgdump if [ $? -eq 0 ]; then echo "Backup created successfully." BACKUPS_TO_DELETE=$(ls -1t $BACKUP_DIR/pg_dumpall-.pgdump \| tail -n +$((BACKUPS_TO_KEEP+1))) if [ -n "$BACKUPS_TO_DELETE" ]; then echo "Deleting old backups:" echo "$BACKUPS_TO_DELETE" echo "$BACKUPS_TO_DELETE" \| xargs -I {} rm -- {} else echo "No backups to delete." fi else echo "Backup creation failed. Old backups will not be deleted." exit 1 fi	string
diagnosticMode.enabled (3) `false`	boolean
architecture (2) `standalone`	string
clusterDomain (2) `${SECRET_DOMAIN}`	string
containerPorts.postgresql (2) `5432`	number
resources.requests.cpu (2) `10m`	string
resources.requests.memory (2) `100Mi`	string
resources.limits.cpu (1) `100m`	string
resources.limits.memory (1) `100Mi`	string
strategy.type (2) `Recreate`	string
volumePermissions.enabled (2) `false`	boolean
volumePermissions.securityContext.fsGroup (1) `0`	number
volumePermissions.securityContext.runAsUser (1) `1000`	number
affinity.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[].matchExpressions[].key (1) `kubernetes.io/arch`	string
affinity.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[].matchExpressions[].operator (1) `In`	string
affinity.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[].matchExpressions[].values[] (1) `- amd64`	string
containerSecurityContext.runAsUser (1) `0`	number
useStatefulSet (1) `true`	boolean

Key

Types

primary.persistence.enabled (13)

true

boolean

primary.persistence.existingClaim (13)

postgresql-data

string

primary.persistence.labels."recurring-job-group.longhorn.io/backup" (1)

enabled

string

primary.persistence.size (1)

10Gi

string

primary.persistence.storageClass (1)

longhorn

string

primary.persistence.subPath (1)

postgresql

string

primary.service.type (4)

LoadBalancer

string

primary.service.loadBalancerIP (3)

${SVC_POSTGRESQL_ADDR}

string

primary.service.annotations."external-dns.alpha.kubernetes.io/hostname" (1)

{{ .Release.Name }}.${SECRET_DOMAIN}

string

primary.service.annotations."io.cilium/lb-ipam-ips" (1)

192.168.2.49

string

primary.service.annotations."tailscale.com/expose" (1)

true

string

primary.service.externalTrafficPolicy (1)

Cluster

string

primary.resources.limits.memory (2)

226M

string

primary.resources.requests.cpu (2)

15m

string

primary.resources.requests.memory (2)

226M

string

primary.containerSecurityContext.enabled (1)

true

boolean

primary.containerSecurityContext.runAsNonRoot (1)

true

boolean

primary.containerSecurityContext.runAsUser (1)

${PUID}

string

primary.extraEnvVars[].name (1)

TZ

string

primary.extraEnvVars[].value (1)

${TIMEZONE}

string

primary.initdb.scriptsSecret (1)

postgresql-init

string

primary.nodeSelector."kubernetes.io/hostname" (1)

eagle.home

string

primary.pdb.create (1)

true

boolean

primary.pdb.minAvailable (1)

number

primary.podSecurityContext.enabled (1)

true

boolean

primary.podSecurityContext.fsGroup (1)

${PGID}

string

image.tag (11)

15.5.0

string

image.repository (10)

bitnami/postgresql

string

image.registry (5)

docker.io

string

image.pullPolicy (1)

IfNotPresent

string

metrics.enabled (7)

true

boolean

metrics.serviceMonitor.enabled (7)

true

boolean

metrics.serviceMonitor.interval (1)

1m

string

metrics.prometheusRule.enabled (2)

true

boolean

global.postgresql.auth.postgresPassword (6)

${SECRET_POSTGRES_PASSWORD}

string

global.postgresql.auth.database (3)

wyoa

string

global.postgresql.auth.existingSecret (2)

main-postgresql-secret

string

global.postgresql.auth.password (2)

${POSTGRES_PASSWORD}

string

global.postgresql.auth.username (2)

j_r0dd

string

auth.enablePostgresUser (5)

true

boolean

auth.postgresPassword (4)

${SECRET_POSTGRES_ADMIN_PASS}

string

auth.database (3)

postgres

string

auth.existingSecret (3)

pgsql-user-secret

string

auth.secretKeys.adminPasswordKey (2)

postgres-password

string

auth.usePasswordFiles (2)

false

boolean

auth.username (1)

mb-scheduler

string

audit.logTimezone (3)

string

audit.clientMinMessages (2)

error

string

audit.containerSecurityContext.enabled (2)

true

boolean

audit.containerSecurityContext.runAsUser (2)

number

audit.logConnections (2)

false

boolean

audit.logDisconnections (2)

false

boolean

audit.logHostname (2)

false

boolean

audit.logLinePrefix (2)

string

audit.persistence.accessModes[] (2)

- ReadWriteOnce

string

audit.persistence.enabled (2)

true

boolean

audit.persistence.existingClaim (2)

string

audit.persistence.mountPath (2)

/bitnami/postgresql

string

audit.persistence.size (2)

8Gi

string

audit.persistence.storageClass (2)

string

audit.persistence.subPath (2)

string

audit.pgAuditLog (2)

string

audit.pgAuditLogCatalog (2)

off

string

audit.updateStrategy.type (2)

RollingUpdate

string

backup.enabled (3)

true

boolean

backup.cronjob.schedule (2)

@daily

string

backup.cronjob.storage.existingClaim (2)

postgresql-backups-v1

string

backup.cronjob.storage.size (1)

8Gi

string

backup.cronjob.storage.storageClass (1)

longhorn

string

backup.cronjob.command[] (1)

- /bin/sh
- -c
- BACKUP_DIR="$PGDUMP_DIR"
BACKUPS_TO_KEEP=7

echo "Current backups in $BACKUP_DIR:"
ls -lh $BACKUP_DIR/pg_dumpall-*.pgdump

pg_dumpall --clean --if-exists --load-via-partition-root --quote-all-identifiers --no-password --file=$BACKUP_DIR/pg_dumpall-$(date '+%Y-%m-%d-%H-%M').pgdump

if [ $? -eq 0 ]; then
  echo "Backup created successfully."

  BACKUPS_TO_DELETE=$(ls -1t $BACKUP_DIR/pg_dumpall-*.pgdump | tail -n +$((BACKUPS_TO_KEEP+1)))

  if [ -n "$BACKUPS_TO_DELETE" ]; then
    echo "Deleting old backups:"
    echo "$BACKUPS_TO_DELETE"

    echo "$BACKUPS_TO_DELETE" | xargs -I {} rm -- {}
  else
    echo "No backups to delete."
  fi
else
  echo "Backup creation failed. Old backups will not be deleted."
  exit 1
fi

string

diagnosticMode.enabled (3)