Pgo

Install

git clone https://github.com/CrunchyData/postgres-operator.git
cd postgres-operator/
git checkout REL_4_6
cd installers/kubectl
kubectl create namespace pgo
kubectl apply -f postgres-operator.yml
./client-setup.sh

• https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/
• https://access.crunchydata.com/documentation/postgres-operator/4.1.1/operatorcli/cli/pgo_create_user/
• https://access.crunchydata.com/documentation/postgres-operator/4.6.2/tutorial/tls/

Install client

https://github.com/jeremybusk/k8s-zabbix-deploy/blob/main/pgo/install-pgo.sh

kubectl -n pgo port-forward svc/postgres-operator 8443:8443

pgo create cluster hostcmd --service-type=NodePort --replica-count=2 --pod-anti-affinity=required

psql -h kub1 -U testuser -p 317xx -d postgres 

pgo create pgadmin -n pgo hostcmd

https://access.crunchydata.com/documentation/postgres-operator/latest/quickstart/

https://access.crunchydata.com/documentation/postgres-operator/latest/

https://access.crunchydata.com/documentation/postgres-operator/4.6.2/architecture/high-availability/

https://www.crunchydata.com/developers/download-postgres/containers/postgres-operator

Expose api

microk8s.kubectl port-forward -n pgo svc/postgres-operator 8443:8443

Run some commands

pgo create cluster hippo
pgo show cluster -n pgo --all
pgo show user hippo --show-system-accounts

pgo create cluster hacluster --replica-count=2 --pod-anti-affinity=preferred --pgbouncer