How to modify the time zone when deploying PostgreSQL using Kubeblocks？

[shashihoushengqia]

The following is the deployment file for PostgreSQL：

apiVersion: apps.kubeblocks.io/v1
kind: Cluster
metadata:
  name: mycluster
  namespace: postgresql
spec:
  terminationPolicy: Delete
  clusterDef: postgresql
  topology: replication
  componentSpecs:
    - name: postgresql
      serviceVersion: "16.9.0"
      env:
        - name: TZ
          value: "Asia/Shanghai"
      disableExporter: false
      replicas: 1
      systemAccounts:
        - name: postgres
          secretRef:
            name: secret
            namespace: postgresql
      resources:
        requests:
          cpu: "2"
          memory: "4Gi"
        limits:
          cpu: "2"
          memory: "4Gi"
      volumeClaimTemplates:
        - name: data
          spec:
            storageClassName: "local-path"
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 100Gi

Then I modified the PostgreSQL parameters through OpsRequest：

kubectl apply -f - <<EOF
apiVersion: operations.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  name: postgresql-reconfigure-static
  namespace: postgresql
spec:
  clusterName: mycluster
  force: false
  reconfigures:
  - componentName: postgresql
    parameters:
      - key: timezone
        value: "Asia/Shanghai"
  preConditionDeadlineSeconds: 0
  type: Reconfiguring
EOF

verify：

Querying time zones in PostgreSQL：

It is still in the UTC time zone. Could you please tell me how to change it to the Shanghai time zone?

[shanshanying]

Hi @shashihoushengqia

What is your KB and PG Addon version ?

Faied to reproduce it on kb 1.0.x

Here is the ops I used for configuration:

apiVersion: operations.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  name: pg-reconfiguring
  namespace: demo
spec:
  type: Reconfiguring
  clusterName: pg-cluster16\  
  force: false
  reconfigures:
  - componentName: postgresql
    parameters:
    - key: timezone
      value: 'Asia/Shanghai'

and the timezone is update as expected GMT -> Asia/Shanghai.