Skip to content
Snippets Groups Projects
Select Git revision
  • ac7b36044ef89a7b03b12f238f61d0cd435954db
  • main default
  • postgresql-ha-16.3.2
  • postgresql-16.7.27
  • monitoring
  • gitlab-runner-0.80.0
  • ingress-nginx
  • postgresql-ha-16.3.1
  • sealed-secrets-2.17.4
  • postgresql-ha-16.3.0
  • rancher-monitoring-107.0.0+up69.8.2-rancher.8
  • rancher-monitoring-crd-107.0.0+up69.8.2-rancher.8
  • cert-manager
  • cluster-autoscaler
  • database-operators
  • postgresql-ha-16.2.3
  • kured protected
  • openstack-cinder-csi
  • postgresql-ha-16.2.2
  • postgresql-16.7.26
  • postgresql-ha-16.2.0
  • postgresql-ha-16.1.2
22 results

fleet-deployments

Name Last commit Last update
adminer
.gitignore
README.md
fleet.yaml

Requirements

PASSWD1=$(uuidgen)
PASSWD2=$(uuidgen)
PASSWD3=$(uuidgen)
kubectl -n database create secret generic --from-literal=password=${PASSWD1} --from-literal=postgres-password=${PASSWD2} --from-literal=repmgr-password=${PASSWD3} postgresql-auth

Create User + Database

$ NEWUSERNAME="newuser"
$ NEWPASSWORD=$(uuidgen)
$ NEWDATABASE="newdatabase"

$ kubectl -n database create secret generic --from-literal=username=${NEWUSERNAME} --from-literal=password=${NEWPASSWORD} --from-literal=database=${NEWDATABASE} user-${NEWUSERNAME}
$ kubectl -n database run postgresql-client --rm -i --tty --image alpine:3.18 --env="PGPASSWORD=${PASSWD2}" --env="NEWUSERNAME=${NEWUSERNAME}" --env="NEWDATABASE=${NEWDATABASE}" --env="NEWPASSWORD=${NEWPASSWORD}" -- /bin/sh
# / apk add postgresql12-client
# / psql -h postgresql.database.svc -U postgres -c "CREATE USER \"${NEWUSERNAME}\" WITH ENCRYPTED PASSWORD '${NEWPASSWORD}';"
# / psql -h postgresql.database.svc -U postgres -c "CREATE DATABASE \"${NEWDATABASE}\" OWNER \"${NEWUSERNAME}\";"