apiVersion: v1
kind: Pod
metadata:
annotations:
cni.projectcalico.org/podIP: ''
cni.projectcalico.org/podIPs: ''
container.seccomp.security.alpha.kubernetes.io/postgresql: runtime/default
creationTimestamp: '2024-09-14T22:46:57Z'
generateName: matrix-postgresql-
labels:
app.kubernetes.io/component: primary
app.kubernetes.io/instance: matrix
app.kubernetes.io/managed-by: Helm
app.kubernetes.io/name: postgresql
app.kubernetes.io/version: 15.4.0
controller-revision-hash: matrix-postgresql-866767dfd9
helm.sh/chart: postgresql-12.12.10
statefulset.kubernetes.io/pod-name: matrix-postgresql-0
managedFields:
- apiVersion: v1
fieldsType: FieldsV1
fieldsV1:
f:metadata:
f:annotations:
f:cni.projectcalico.org/podIP: {}
f:cni.projectcalico.org/podIPs: {}
manager: calico
operation: Update
time: '2024-09-14T22:47:03Z'
- apiVersion: v1
fieldsType: FieldsV1
fieldsV1:
f:metadata:
f:generateName: {}
f:labels:
.: {}
f:app.kubernetes.io/component: {}
f:app.kubernetes.io/instance: {}
f:app.kubernetes.io/managed-by: {}
f:app.kubernetes.io/name: {}
f:app.kubernetes.io/version: {}
f:controller-revision-hash: {}
f:helm.sh/chart: {}
f:statefulset.kubernetes.io/pod-name: {}
f:ownerReferences:
.: {}
k:{"uid":"fc2ac63d-a900-4610-8b38-b411e2dc54f8"}:
.: {}
f:apiVersion: {}
f:blockOwnerDeletion: {}
f:controller: {}
f:kind: {}
f:name: {}
f:uid: {}
f:spec:
f:affinity:
.: {}
f:podAntiAffinity:
.: {}
f:preferredDuringSchedulingIgnoredDuringExecution: {}
f:containers:
k:{"name":"postgresql"}:
.: {}
f:env:
.: {}
k:{"name":"BITNAMI_DEBUG"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"PGDATA"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_CLIENT_MIN_MESSAGES"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_ENABLE_LDAP"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_ENABLE_TLS"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_LOG_CONNECTIONS"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_LOG_DISCONNECTIONS"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_LOG_HOSTNAME"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_PGAUDIT_LOG_CATALOG"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_PORT_NUMBER"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_SHARED_PRELOAD_LIBRARIES"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRESQL_VOLUME_DIR"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRES_DATABASE"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRES_INITDB_ARGS"}:
.: {}
f:name: {}
f:value: {}
k:{"name":"POSTGRES_PASSWORD"}:
.: {}
f:name: {}
f:valueFrom:
.: {}
f:secretKeyRef:
.: {}
f:key: {}
f:name: {}
k:{"name":"POSTGRES_POSTGRES_PASSWORD"}:
.: {}
f:name: {}
f:valueFrom:
.: {}
f:secretKeyRef:
.: {}
f:key: {}
f:name: {}
k:{"name":"POSTGRES_USER"}:
.: {}
f:name: {}
f:value: {}
f:image: {}
f:imagePullPolicy: {}
f:livenessProbe:
.: {}
f:exec:
.: {}
f:command: {}
f:failureThreshold: {}
f:initialDelaySeconds: {}
f:periodSeconds: {}
f:successThreshold: {}
f:timeoutSeconds: {}
f:name: {}
f:ports:
.: {}
k:{"containerPort":5432,"protocol":"TCP"}:
.: {}
f:containerPort: {}
f:name: {}
f:protocol: {}
f:readinessProbe:
.: {}
f:exec:
.: {}
f:command: {}
f:failureThreshold: {}
f:initialDelaySeconds: {}
f:periodSeconds: {}
f:successThreshold: {}
f:timeoutSeconds: {}
f:resources:
.: {}
f:requests:
.: {}
f:cpu: {}
f:memory: {}
f:securityContext:
.: {}
f:allowPrivilegeEscalation: {}
f:capabilities:
.: {}
f:drop: {}
f:runAsGroup: {}
f:runAsNonRoot: {}
f:runAsUser: {}
f:seccompProfile:
.: {}
f:type: {}
f:terminationMessagePath: {}
f:terminationMessagePolicy: {}
f:volumeMounts:
.: {}
k:{"mountPath":"/bitnami/postgresql"}:
.: {}
f:mountPath: {}
f:name: {}
k:{"mountPath":"/dev/shm"}:
.: {}
f:mountPath: {}
f:name: {}
f:dnsPolicy: {}
f:enableServiceLinks: {}
f:hostname: {}
f:restartPolicy: {}
f:schedulerName: {}
f:securityContext:
.: {}
f:fsGroup: {}
f:serviceAccount: {}
f:serviceAccountName: {}
f:subdomain: {}
f:terminationGracePeriodSeconds: {}
f:volumes:
.: {}
k:{"name":"data"}:
.: {}
f:name: {}
f:persistentVolumeClaim:
.: {}
f:claimName: {}
k:{"name":"dshm"}:
.: {}
f:emptyDir:
.: {}
f:medium: {}
f:name: {}
f:status:
f:conditions:
.: {}
k:{"type":"ContainersReady"}:
.: {}
f:lastProbeTime: {}
f:lastTransitionTime: {}
f:status: {}
f:type: {}
k:{"type":"Initialized"}:
.: {}
f:lastProbeTime: {}
f:lastTransitionTime: {}
f:status: {}
f:type: {}
k:{"type":"PodScheduled"}:
.: {}
f:lastProbeTime: {}
f:lastTransitionTime: {}
f:message: {}
f:reason: {}
f:status: {}
f:type: {}
k:{"type":"Ready"}:
.: {}
f:lastProbeTime: {}
f:lastTransitionTime: {}
f:status: {}
f:type: {}
f:containerStatuses: {}
f:hostIP: {}
f:phase: {}
f:podIP: {}
f:podIPs:
.: {}
k:{"ip":"172.18.117.194"}:
.: {}
f:ip: {}
f:startTime: {}
manager: k3s
operation: Update
time: '2025-10-19T10:16:36Z'
name: matrix-postgresql-0
namespace: matrix
ownerReferences:
- apiVersion: apps/v1
blockOwnerDeletion: true
controller: true
kind: StatefulSet
name: matrix-postgresql
uid: fc2ac63d-a900-4610-8b38-b411e2dc54f8
resourceVersion: '3508118845'
uid: 7d81f170-98f0-4e6e-b1b9-8844fad915b6
spec:
affinity:
podAntiAffinity:
preferredDuringSchedulingIgnoredDuringExecution:
- podAffinityTerm:
labelSelector:
matchLabels:
app.kubernetes.io/component: primary
app.kubernetes.io/instance: matrix
app.kubernetes.io/name: postgresql
topologyKey: kubernetes.io/hostname
weight: 1
containers:
- env:
- name: BITNAMI_DEBUG
value: 'false'
- name: POSTGRESQL_PORT_NUMBER
value: '5432'
- name: POSTGRESQL_VOLUME_DIR
value: /bitnami/postgresql
- name: PGDATA
value: /bitnami/postgresql/data
- name: POSTGRES_USER
value: synapse
- name: POSTGRES_PASSWORD
valueFrom:
secretKeyRef:
key: password
name: matrix-postgresql
- name: POSTGRES_POSTGRES_PASSWORD
valueFrom:
secretKeyRef:
key: postgres-password
name: matrix-postgresql
- name: POSTGRES_DATABASE
value: synapse
- name: POSTGRES_INITDB_ARGS
value: --lc-collate=C --lc-ctype=C
- name: POSTGRESQL_ENABLE_LDAP
value: 'no'
- name: POSTGRESQL_ENABLE_TLS
value: 'no'
- name: POSTGRESQL_LOG_HOSTNAME
value: 'false'
- name: POSTGRESQL_LOG_CONNECTIONS
value: 'false'
- name: POSTGRESQL_LOG_DISCONNECTIONS
value: 'false'
- name: POSTGRESQL_PGAUDIT_LOG_CATALOG
value: 'off'
- name: POSTGRESQL_CLIENT_MIN_MESSAGES
value: error
- name: POSTGRESQL_SHARED_PRELOAD_LIBRARIES
value: pgaudit
image: docker.io/bitnami/postgresql:15.4.0-debian-11-r45
imagePullPolicy: IfNotPresent
livenessProbe:
exec:
command:
- /bin/sh
- -c
- exec pg_isready -U "synapse" -d "dbname=synapse" -h 127.0.0.1 -p 5432
failureThreshold: 6
initialDelaySeconds: 30
periodSeconds: 10
successThreshold: 1
timeoutSeconds: 5
name: postgresql
ports:
- containerPort: 5432
name: tcp-postgresql
protocol: TCP
readinessProbe:
exec:
command:
- /bin/sh
- -c
- -e
- 'exec pg_isready -U "synapse" -d "dbname=synapse" -h 127.0.0.1 -p 5432
[ -f /opt/bitnami/postgresql/tmp/.initialized ] || [ -f /bitnami/postgresql/.initialized
]
'
failureThreshold: 6
initialDelaySeconds: 5
periodSeconds: 10
successThreshold: 1
timeoutSeconds: 5
resources:
requests:
cpu: 250m
memory: 256Mi
securityContext:
allowPrivilegeEscalation: false
capabilities:
drop:
- ALL
runAsGroup: 0
runAsNonRoot: true
runAsUser: 1001
seccompProfile:
type: RuntimeDefault
terminationMessagePath: /dev/termination-log
terminationMessagePolicy: File
volumeMounts:
- mountPath: /dev/shm
name: dshm
- mountPath: /bitnami/postgresql
name: data
- mountPath: /var/run/secrets/kubernetes.io/serviceaccount
name: kube-api-access-fl8s9
readOnly: true
dnsPolicy: ClusterFirst
enableServiceLinks: true
hostname: matrix-postgresql-0
nodeName: sed-infra-server-master-mcg58ax2-aa1e3892
preemptionPolicy: PreemptLowerPriority
priority: 0
restartPolicy: Always
schedulerName: default-scheduler
securityContext:
fsGroup: 1001
serviceAccount: default
serviceAccountName: default
subdomain: matrix-postgresql-hl
terminationGracePeriodSeconds: 30
tolerations:
- effect: NoExecute
key: node.kubernetes.io/not-ready
operator: Exists
tolerationSeconds: 300
- effect: NoExecute
key: node.kubernetes.io/unreachable
operator: Exists
tolerationSeconds: 300
volumes:
- name: data
persistentVolumeClaim:
claimName: data-matrix-postgresql-0
- emptyDir:
medium: Memory
name: dshm
- name: kube-api-access-fl8s9
projected:
defaultMode: 420
sources:
- serviceAccountToken:
expirationSeconds: 3607
path: token
- configMap:
items:
- key: ca.crt
path: ca.crt
name: kube-root-ca.crt
- downwardAPI:
items:
- fieldRef:
apiVersion: v1
fieldPath: metadata.namespace
path: namespace
status:
conditions:
- lastProbeTime: null
lastTransitionTime: '2024-09-14T22:46:59Z'
status: 'True'
type: Initialized
- lastProbeTime: null
lastTransitionTime: '2025-10-19T10:16:09Z'
status: 'True'
type: Ready
- lastProbeTime: null
lastTransitionTime: '2025-10-19T10:16:09Z'
status: 'True'
type: ContainersReady
- lastProbeTime: null
lastTransitionTime: '2024-09-14T22:46:59Z'
status: 'True'
type: PodScheduled
containerStatuses:
- containerID: containerd://54a5c8fe03c537f744d82c04e7420972d89c0fa60f12564e7c850b9a9e83c41c
image: docker.io/bitnami/postgresql:15.4.0-debian-11-r45
imageID: docker.io/bitnami/postgresql@sha256:5dba7e6a514d5d628d484d23212dcaf3d7c5816af1d4970649547a03a99f78dc
lastState:
terminated:
containerID: containerd://5070454168db9afc001f1e4679e103c915b8047ba0a718033340b9ec0f87ef4c
exitCode: 255
finishedAt: '2025-10-19T10:15:24Z'
reason: Unknown
startedAt: '2025-10-10T05:12:34Z'
name: postgresql
ready: true
restartCount: 13
started: true
state:
running:
startedAt: '2025-10-19T10:15:57Z'
hostIP: 192.168.1.3
phase: Running
podIP: 172.18.117.194
podIPs:
- ip: 172.18.117.194
qosClass: Burstable
startTime: '2024-09-14T22:46:59Z'