postgresql helm release

No introduction found. Create it?

Name	Repo	Stars	Version	Timestamp
postgresql	jr0dd/home-ops	46	13.2.25	a year ago

Name

Repo

Stars

Version

Timestamp

postgresql

jr0dd/home-ops

13.2.25

a year ago

Key	Types
primary.persistence.enabled (9) `true`	boolean
primary.persistence.existingClaim (9) `postgresql-data`	string
primary.persistence.labels."recurring-job-group.longhorn.io/backup" (1) `enabled`	string
primary.persistence.subPath (1) `postgresql-17`	string
primary.resources.limits.memory (2) `1024Mi`	string
primary.resources.limits.cpu (1) `1000m`	string
primary.resources.requests.cpu (2) `500m`	string
primary.resources.requests.memory (2) `512Mi`	string
primary.service.type (2) `LoadBalancer`	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.service.loadBalancerIP (1) `10.172.90.30`	string
primary.containerSecurityContext.enabled (1) `true`	boolean
primary.containerSecurityContext.runAsNonRoot (1) `true`	boolean
primary.containerSecurityContext.runAsUser (1) `${PUID}`	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
primary.resourcesPreset (1) `micro`	string
image.repository (8) `bitnami/postgresql`	string
image.tag (8) `15.5.0`	string
image.registry (5) `docker.io`	string
image.pullPolicy (1) `IfNotPresent`	string
metrics.enabled (6) `true`	boolean
metrics.serviceMonitor.enabled (6) `true`	boolean
metrics.prometheusRule.enabled (1) `true`	boolean
global.postgresql.auth.database (4) `sso`	string
global.postgresql.auth.postgresPassword (4) `${POSTGRES_SSO_ADMIN_PASSWORD}`	string
global.postgresql.auth.password (3) `${POSTGRES_SSO_PASSWORD}`	string
global.postgresql.auth.username (3) `${POSTGRES_SSO_USERNAME}`	string
global.postgresql.auth.existingSecret (1) `postgresql-secret`	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
auth.enablePostgresUser (3) `true`	boolean
auth.postgresPassword (3) `${SECRET_GRAFANA_ADMIN_PASSWORD}`	string
auth.database (2) `main`	string
auth.existingSecret (2) `pgsql-user-secret`	string
auth.secretKeys.adminPasswordKey (2) `postgres-password`	string
auth.usePasswordFiles (2) `false`	boolean
containerPorts.postgresql (2) `5432`	number
volumePermissions.enabled (2) `false`	boolean
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
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
backup.cronjob.storage.size (1) `40Gi`	string
backup.cronjob.storage.storageClass (1) `longhorn`	string
backup.enabled (1) `true`	boolean
containerSecurityContext.runAsUser (1) `0`	number
diagnosticMode.enabled (1) `false`	boolean

Key

Types

primary.persistence.enabled (9)

true

boolean

primary.persistence.existingClaim (9)

postgresql-data

string

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

enabled

string

primary.persistence.subPath (1)

postgresql-17

string

primary.resources.limits.memory (2)

1024Mi

string

primary.resources.limits.cpu (1)

1000m

string

primary.resources.requests.cpu (2)

500m

string

primary.resources.requests.memory (2)

512Mi

string

primary.service.type (2)

LoadBalancer

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.service.loadBalancerIP (1)

10.172.90.30

string

primary.containerSecurityContext.enabled (1)

true

boolean

primary.containerSecurityContext.runAsNonRoot (1)

true

boolean

primary.containerSecurityContext.runAsUser (1)

${PUID}

string

primary.pdb.create (1)

true

boolean

primary.pdb.minAvailable (1)

number

primary.podSecurityContext.enabled (1)

true

boolean

primary.podSecurityContext.fsGroup (1)

${PGID}

string

primary.resourcesPreset (1)

micro

string

image.repository (8)

bitnami/postgresql

string

image.tag (8)

15.5.0

string

image.registry (5)

docker.io

string

image.pullPolicy (1)

IfNotPresent

string

metrics.enabled (6)

true

boolean

metrics.serviceMonitor.enabled (6)

true

boolean

metrics.prometheusRule.enabled (1)

true

boolean

global.postgresql.auth.database (4)

sso

string

global.postgresql.auth.postgresPassword (4)

${POSTGRES_SSO_ADMIN_PASSWORD}

string

global.postgresql.auth.password (3)

${POSTGRES_SSO_PASSWORD}

string

global.postgresql.auth.username (3)

${POSTGRES_SSO_USERNAME}

string

global.postgresql.auth.existingSecret (1)

postgresql-secret

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

auth.enablePostgresUser (3)

true

boolean

auth.postgresPassword (3)

${SECRET_GRAFANA_ADMIN_PASSWORD}

string

auth.database (2)

main

string

auth.existingSecret (2)

pgsql-user-secret

string

auth.secretKeys.adminPasswordKey (2)

postgres-password

string

auth.usePasswordFiles (2)

false

boolean

containerPorts.postgresql (2)

number

volumePermissions.enabled (2)

false

boolean

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

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

backup.cronjob.storage.size (1)