deploy-pg.yaml

apiVersion: kubedb.com/v1alpha2
kind: Postgres
metadata:
  name: pg-tls-15-3-new
  namespace: poc
spec:
  version: "15.3"
  replicas: 1
  configSecret:
    name: user-conf
  standbyMode: Hot
  storageType: Durable
  tls:
    issuerRef:
      apiGroup: cert-manager.io
      name: postgres-ca-issuer
      kind: Issuer
    certificates:
    - alias: server
      subject:
        organizations:
        - kubedb:server
      dnsNames:
      - localhost
      ipAddresses:
      - "127.0.0.1"
  storage:
    storageClassName: "linode-block-storage"
    accessModes:
    - ReadWriteOnce
    resources:
      requests:
        storage: 1Gi
  terminationPolicy: WipeOut

user.conf

log_min_messages=DEBUG5
log_min_error_statement=DEBUG5

create the secret:
kubectl create secret generic user-conf -n poc --from-file=./user.conf