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.

   kbcli

   kbcli cluster stop mycluster -n demo

   OpsRequest

   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

   Edit cluster YAML file

   Configure replicas as 0 to delete pods.

   apiVersion: apps.kubeblocks.io/v1alpha1
   kind: Cluster
   metadata:
     name: mycluster
     namespace: demo
   spec:
     clusterDefinitionRef: postgresql
     clusterVersionRef: postgresql-14.8.0
     terminationPolicy: Delete
     componentSpecs:
     - name: postgresql
       componentDefRef: postgresql
       disableExporter: true  
       replicas: 0
   ......

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

   kbcli

   kbcli cluster list -n demo

   kubectl

   kubectl get cluster mycluster -n demo

Start a cluster

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

   kbcli

   kbcli cluster start mycluster -n demo

   OpsRequest

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

   Edit cluster YAML file

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

   kubectl edit cluster mycluster -n demo
   >
   apiVersion: apps.kubeblocks.io/v1alpha1
   kind: Cluster
   metadata:
     name: mycluster
   spec:
     clusterDefinitionRef: postgresql
     clusterVersionRef: postgresql-14.8.0
     terminationPolicy: Delete
     componentSpecs:
     - name: mysql
       componentDefRef: mysql
       disableExporter: true
       replicas: 1
   ......

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

   kbcli

   kbcli cluster list -n demo

   kubectl

   kubectl get cluster mycluster -n demo