Top
Enterprise Postgres 18 for Kubernetes User's Guide

5.14.4 Using Local Storage

If object storage is not available, use local storage.

5.14.4.1 Exporting Statistics Files to FEPCluster in a Validation Environment

Execute FEPAction and export the statistics whose performance is guaranteed in the verification environment to the file system /database/userdata/action/local/ on the container.

Example) Definition example of FEPCluster custom resource

spec:
  fep:
    fixedStats: 
      endpoint: #Required
        protocol: local 

Example) Definition example of FEPAction custom resource

apiVersion: fep.fujitsu.io/v1
kind: FEPAction
metadata:
  name: fep-action-fixdStats
spec:
  fepAction:
    targetClusterName: new-fep
    type: fixed_stats 
    args: 
      fixedStatsType: export
      targetDb: mydatabase
      file: file_name.dump
      targetStats: effective

5.14.4.2 Deploying Statistics Files to FEPCluster in a Production Environment

Deploy the statistics binary file under /database/userdata/fixedstats/action/local/ in the primary database of FEPCluster in the production environment.

kubectl cp <file-to-copy> \
<namespace>/<primary-pod-name>:/database/userdata/fixedstats/action/local/ -c fep-patroni

5.14.4.3 Specify File Names for FEPCluster Custom Resources

Specify the name of the deployed statistics binary file for the FEPCluster custom resource.

Example) Definition example of FEPCluster custom resource

spec:
  fep:
    fixedStats: 
      schedule1: #Required, N is the identification number
        update: true
        fixSchedule: "0 20 * * 5"  #Required
        unfixSchedule: "0 23 * * 5" #Optional,  If not specified, do not unfreeze
        targetDb: mydatabase #Required 
        file: file_name.dump
      endpoint:
        protocol: local