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}\";"