Skip to content

Latest commit

 

History

History
29 lines (22 loc) · 1.37 KB

README.md

File metadata and controls

29 lines (22 loc) · 1.37 KB
Raw

Example for k8s

Pre-requirements

  • kubernetes cluster up and running
  • local kubectl tool

How to install the example

  • Create namespace by kubectl create -f ./namespace/
  • Create configs: kubectl create -f ./configs/
  • Create volumes kubectl create -f ./volumes/
  • Create services kubectl create -f ./services/
  • Create nodes kubectl create -f ./nodes/
  • Create pgpool kubectl create -f ./pgpool/
  • See containers are running kubectl get pod --namespace=mysystem (give it some time to warm up the cluster after all containers are running)
  • Test by commands and see status of the cluster
# cluster status on nodes
kubectl get pod | grep db-node  | awk '{print $1}' | while read pod ; do echo "$pod": ; kubectl  exec $pod -- bash -c 'gosu postgres repmgr cluster show' ; done

# cluster status on pgpool
kubectl get pod | grep pgpool | awk '{print $1 }' | while read pod; do echo "$pod": ;kubectl exec $pod -- bash -c 'PGCONNECT_TIMEOUT=$CHECK_PGCONNECT_TIMEOUT  PGPASSWORD=$CHECK_PASSWORD psql -U $CHECK_USER -h 127.0.0.1 template1 -c "show pool_nodes"' ; done

Persistence in the cluster (AWS example)

  • Example1: Modify volume objects in the files ./volumes/volume-*.yml and un-comment section about EBS
  • Example2: Instead of having emptyDir in configurations for nodes in files nodes/*.yml you should un-comment lines in the end of the files