Stop/Start PostgreSQL Cluster

You can stop/start a cluster to save computing resources. When a cluster is stopped, the computing resources of this cluster are released, which means the pods of Kubernetes are released, but the storage resources are reserved. You can start this cluster again to restore it to the state it was in before it was stopped.

Stop a cluster

1. Configure the name of your cluster and run the command below to stop this cluster.

   Apply an OpsRequest to stop a cluster.

   kubectl apply -f - <<EOF
   apiVersion: apps.kubeblocks.io/v1alpha1
   kind: OpsRequest
   metadata:
     name: ops-stop
     namespace: demo
   spec:
     clusterName: mycluster
     type: Stop
   EOF
   

   Configure replicas as 0 to delete pods.

   kubectl edit cluster mycluster -n demo
   

   Edit the value of spec.componentSpecs.replicas.

   ...
   spec:
     clusterDefinitionRef: postgresql
     clusterVersionRef: postgresql-14.8.0
     terminationPolicy: Delete
     componentSpecs:
     - name: postgresql
       componentDefRef: postgresql
       disableExporter: true  
       replicas: 0 # Change this value
   ...
   

   kbcli cluster stop mycluster -n demo
   

2. Check the status of the cluster to see whether it is stopped.

   kubectl get cluster mycluster -n demo
   

   kbcli cluster list -n demo
   

Start a cluster

1. Configure the name of your cluster and run the command below to start this cluster.

   kubectl apply -f - <<EOF
   apiVersion: apps.kubeblocks.io/v1alpha1
   kind: OpsRequest
   metadata:
     name: ops-start
     namespace: demo
   spec:
     clusterName: mycluster
     type: Start
   EOF 
   

   Change replicas back to the original amount to start this cluster again.

   kubectl edit cluster mycluster -n demo
   

   Edit the value of spec.componentSpecs.replicas.

   ...
   spec:
     clusterDefinitionRef: postgresql
     clusterVersionRef: postgresql-14.8.0
     terminationPolicy: Delete
     componentSpecs:
     - name: mysql
       componentDefRef: mysql
       disableExporter: true
       replicas: 1 # Change this value
   ...
   

   kbcli cluster start mycluster -n demo
   

2. Check the status of the cluster to see whether it is running again.

   kubectl get cluster mycluster -n demo
   

   kbcli cluster list -n demo