Skip to content

antony@notes:~/misc$ cat "FETC.md"

FETC

2025-05-04· misc

FETC

postgresql

$ kubectl apply -f https://raw.githubusercontent.com/rancher/local-path-provisioner/master/deploy/local-path-storage.yaml

$ kubectl patch storageclass local-path -p '{"metadata": {"annotations":{"storageclass.kubernetes.io/is-default-class":"true"}}}'

$ cat pv.yaml
apiVersion: v1
kind: PersistentVolume
metadata:
  name: pv-for-pg
  labels:
    type: local
spec:
  capacity:
    storage: 4Gi
  volumeMode: Filesystem
  accessModes:
  - ReadWriteOnce
  persistentVolumeReclaimPolicy: Retain
  storageClassName: "local-path"
  hostPath:
    path: /home/bigred/pv
  nodeAffinity:
    required:
      nodeSelectorTerms:
      - matchExpressions:
        - key: kubernetes.io/hostname
          operator: In
          values:
          - localhost.localdomain

---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: pg-pvc
  namespace: psql-system
spec:
  storageClassName: "local-path"
  accessModes:
  - ReadWriteOnce
  resources:
    requests:
      storage: 4Gi
	  
$ kubectl apply -f pv.yaml

$ helm repo add bitnami https://charts.bitnami.com/bitnami

$ kubectl create ns psql-system

$ helm template --namespace psql-system dev-pg bitnami/postgresql --version 11.9.13 --set primary.persistence.existingClaim=pg-pvc,auth.postgresPassword=pgpass,volumePermissions.enabled=true,primary.service.type='NodePort',image.tag='14.8.0' > ~/workload/postgresql/postgresql.yaml

$ kubectl apply -f ~/workload/postgresql/postgresql.yaml


kubectl run -n psql-system dev-pg-postgresql-client --rm --tty -i --restart='Never' --namespace psql-system --image docker.io/bitnami/postgresql:14.8.0 --env="PGPASSWORD=$POSTGRES_PASSWORD" \
      --command -- psql --host dev-pg-postgresql -U postgres -d postgres -p 5432

Minio

curl https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-3 | bash

kubectl create ns minio-system

mkdir -p ~/workload/minio

helm template minio \
  --namespace=minio-system \
  --set auth.rootUser=admin \
  --set auth.rootPassword=admin123 \
  --set image.registry=docker.io \
  --set image.repository=bitnami/minio \
  --set image.tag=2022.3.14-debian-10-r0 \
  --set networkPolicy.enabled=false \
  --set persistence.storageClass=local-path \
  --set persistence.size=100Gi \
  --set service.type=NodePort \
  --set containerSecurityContext.enabled=false \
    oci://registry-1.docker.io/bitnamicharts/minio > ~/workload/minio/minio.yaml

kubectl apply -f ~/workload/minio/minio.yaml