SGDbOps

Kind: SGDbOps

listKind: SGDbOpsList

plural: sgdbops

singular: sgdbops

shortNames sgdo

The SGDbOps custom resource represents database operations that are performed on a Postgres cluster.

Example:

apiVersion: stackgres.io/v1
kind: SGDbOps
metadata:
  name: benchmark
spec:
 sgCluster: my-cluster
 op: benchmark
 maxRetries: 1
 benchmark:
   type: pgbench
   pgbench:
     databaseSize: 1Gi
     duration: P0DT0H10M0S
     concurrentClients: 10
     threads: 10
   connectionType: primary-service

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

apiVersion ✓ string stackgres.io/v1
kind ✓ string SGDbOps
metadata ✓ ✓ object Refer to the Kubernetes API documentation for the fields of the metadata field.
spec ✓ ✓ object
status ✓ object

SGDbOps.spec

↩ Parent

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

op ✓ ✓ string The kind of operation that will be performed on the SGCluster. Available operations are:

  • benchmark: run a benchmark on the specified SGCluster and report the results in the status.
  • vacuum: perform a vacuum operation on the specified SGCluster.
  • repack: run pg_repack command on the specified SGCluster.
  • majorVersionUpgrade: perform a major version upgrade of PostgreSQL using pg_upgrade command.
  • restart: perform a restart of the cluster.
  • minorVersionUpgrade: perform a minor version upgrade of PostgreSQL.
  • securityUpgrade: perform a security upgrade of the cluster.
sgCluster ✓ ✓ string The name of SGCluster on which the operation will be performed.
benchmark ✓ object Configuration of the benchmark
majorVersionUpgrade ✓ object Configuration of major version upgrade (see also pg_upgrade command)
maxRetries ✓ integer The maximum number of retries the operation is allowed to do after a failure.

A value of 0 (zero) means no retries are made. Can not be greater than 10. Defaults to: 0.

minorVersionUpgrade ✓ object Configuration of minor version upgrade
repack ✓ object Configuration of pg_repack command
restart ✓ object Configuration of restart
runAt ✓ string An ISO 8601 date, that holds UTC scheduled date of the operation execution.

If not specified or if the date it’s in the past, it will be interpreted ASAP.

scheduling ✓ object Pod custom node scheduling and affinity configuration
securityUpgrade ✓ object Configuration of security upgrade
timeout ✓ string An ISO 8601 duration in the format PnDTnHnMn.nS, that specifies a timeout after which the operation execution will be canceled.

If the operation can not be performed due to timeout expiration, the condition Failed will have a status of True and the reason will be OperationTimedOut.

If not specified the operation will never fail for timeout expiration.

vacuum ✓ object Configuration of vacuum operation

SGDbOps.spec.benchmark

↩ Parent

Configuration of the benchmark

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

type ✓ ✓ string The type of benchmark that will be performed on the SGCluster. Available benchmarks are:

  • pgbench: run pgbench on the specified SGCluster and report the results in the status.

connectionType ✓ string Specify the service where the benchmark will connect to:

  • primary-service: Connect to the primary service

  • replicas-service: Connect to the replicas service

    • pgbench ✓ object Configuration of pgbench benchmark

    SGDbOps.spec.benchmark.pgbench

    ↩ Parent

    Configuration of pgbench benchmark

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    databaseSize ✓ ✓ string Size of the database to generate. This size is specified either in Mebibytes, Gibibytes or Tebibytes (multiples of 2^20, 2^30 or 2^40, respectively).
    duration ✓ ✓ string An ISO 8601 duration in the format PnDTnHnMn.nS, that specifies how long the benchmark will run.
    concurrentClients ✓ integer Number of clients simulated, that is, number of concurrent database sessions. Defaults to: 1.
    threads ✓ integer Number of worker threads within pgbench. Using more than one thread can be helpful on multi-CPU machines. Clients are distributed as evenly as possible among available threads. Default is 1.
    usePreparedStatements ✓ boolean Use extended query protocol with prepared statements. Defaults to: false.

    SGDbOps.spec.majorVersionUpgrade

    ↩ Parent

    Configuration of major version upgrade (see also pg_upgrade command)

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    backupPath ✓ string The path were the backup is stored. If not set this field is filled up by the operator.

    When provided will indicate were the backups and WAL files will be stored.

    The path should be different from the current .spec.configurations.backups[].path value for the target SGCluster in order to avoid mixing WAL files of two distinct major versions of postgres.

    check ✓ boolean If true does some checks to see if the cluster can perform a major version upgrade without changing any data. Defaults to: false.
    clone ✓ boolean If true use efficient file cloning (also known as “reflinks” on some systems) instead of copying files to the new cluster. This can result in near-instantaneous copying of the data files, giving the speed advantages of link while leaving the old cluster untouched. This option is mutually exclusive with link. Defaults to: false.

    File cloning is only supported on some operating systems and file systems. If it is selected but not supported, the pg_upgrade run will error. At present, it is supported on Linux (kernel 4.5 or later) with Btrfs and XFS (on file systems created with reflink support), and on macOS with APFS.

    link ✓ boolean If true use hard links instead of copying files to the new cluster. This option is mutually exclusive with clone. Defaults to: false.
    postgresExtensions ✓ []object A major version upgrade can not be performed if a required extension is not present for the target major version of the upgrade. In those cases you will have to provide the target extension version of the extension for the target major version of postgres. Beware that in some cases it is not possible to upgrade an extension alongside postgres. This is the case for PostGIS or timescaledb. In such cases you will have to upgrade the extension before or after the major version upgrade. Please make sure you read the documentation of each extension in order to understand if it is possible to upgrade it during a major version upgrade of postgres.
    postgresVersion ✓ string The target postgres version that must have the same major version of the target SGCluster.
    sgPostgresConfig ✓ string The postgres config that must have the same major version of the target postgres version.
    toInstallPostgresExtensions ✓ []object The list of Postgres extensions to install.

    This section is filled by the operator.

    SGDbOps.spec.majorVersionUpgrade.postgresExtensions[index]

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    name ✓ ✓ string The name of the extension to deploy.
    publisher ✓ string The id of the publisher of the extension to deploy. If not specified com.ongres will be used by default.

    Default: com.ongres
    repository ✓ string The repository base URL from where to obtain the extension to deploy.

    This section is filled by the operator.

    version ✓ string The version of the extension to deploy. If not specified version of stable channel will be used by default and if only a version is available that one will be used.

    SGDbOps.spec.majorVersionUpgrade.toInstallPostgresExtensions[index]

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    name ✓ ✓ string The name of the extension to install.
    postgresVersion ✓ ✓ string The postgres major version of the extension to install.
    publisher ✓ ✓ string The id of the publisher of the extension to install.
    repository ✓ ✓ string The repository base URL from where the extension will be installed from.
    version ✓ ✓ string The version of the extension to install.
    build ✓ string The build version of the extension to install.
    extraMounts ✓ []string The extra mounts of the extension to install.

    SGDbOps.spec.minorVersionUpgrade

    ↩ Parent

    Configuration of minor version upgrade

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    method ✓ string The method used to perform the minor version upgrade operation. Available methods are:

    • InPlace: the in-place method does not require more resources than those that are available. In case only an instance of the StackGres cluster is present this mean the service disruption will last longer so we encourage use the reduced impact restart and especially for a production environment.
    • ReducedImpact: this procedure is the same as the in-place method but require additional resources in order to spawn a new updated replica that will be removed when the procedure completes.
    postgresVersion ✓ string The target postgres version that must have the same major version of the target SGCluster.

    SGDbOps.spec.repack

    ↩ Parent

    Configuration of pg_repack command

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    databases ✓ []object List of database to vacuum or repack, don’t specify to select all databases
    excludeExtension ✓ boolean If true don’t repack tables which belong to specific extension. Defaults to: false.
    noAnalyze ✓ boolean If true don’t analyze at end. Defaults to: false.
    noKillBackend ✓ boolean If true don’t kill other backends when timed out. Defaults to: false.
    noOrder ✓ boolean If true do vacuum full instead of cluster. Defaults to: false.
    waitTimeout ✓ string If specified, an ISO 8601 duration format PnDTnHnMn.nS to set a timeout to cancel other backends on conflict.

    SGDbOps.spec.repack.databases[index]

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    name ✓ ✓ string the name of the database
    excludeExtension ✓ boolean If true don’t repack tables which belong to specific extension. Defaults to: false.
    noAnalyze ✓ boolean If true don’t analyze at end. Defaults to: false.
    noKillBackend ✓ boolean If true don’t kill other backends when timed out. Defaults to: false.
    noOrder ✓ boolean If true do vacuum full instead of cluster. Defaults to: false.
    waitTimeout ✓ string If specified, an ISO 8601 duration format PnDTnHnMn.nS to set a timeout to cancel other backends on conflict.

    SGDbOps.spec.restart

    ↩ Parent

    Configuration of restart

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    method ✓ string The method used to perform the restart operation. Available methods are:

    • InPlace: the in-place method does not require more resources than those that are available. In case only an instance of the StackGres cluster is present this mean the service disruption will last longer so we encourage use the reduced impact restart and especially for a production environment.
    • ReducedImpact: this procedure is the same as the in-place method but require additional resources in order to spawn a new updated replica that will be removed when the procedure completes.
    onlyPendingRestart ✓ boolean By default all Pods are restarted. Setting this option to true allow to restart only those Pods which are in pending restart state as detected by the operation. Defaults to: false.

    SGDbOps.spec.scheduling

    ↩ Parent

    Pod custom node scheduling and affinity configuration

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    nodeAffinity ✓ object Node affinity is a group of node affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#nodeaffinity-v1-core
    nodeSelector ✓ map[string]string NodeSelector is a selector which must be true for the pod to fit on a node. Selector which must match a node’s labels for the pod to be scheduled on that node. More info: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/
    podAffinity ✓ object Pod affinity is a group of inter pod affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#podaffinity-v1-core
    podAntiAffinity ✓ object Pod anti affinity is a group of inter pod anti affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#podantiaffinity-v1-core
    priorityClassName ✓ string If specified, indicates the pod’s priority. “system-node-critical” and “system-cluster-critical” are two special keywords which indicate the highest priorities with the former being the highest priority. Any other name must be defined by creating a PriorityClass object with that name. If not specified, the pod priority will be default or zero if there is no default.
    tolerations ✓ []object If specified, the pod’s tolerations.

    SGDbOps.spec.scheduling.nodeAffinity

    ↩ Parent

    Node affinity is a group of node affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#nodeaffinity-v1-core

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    preferredDuringSchedulingIgnoredDuringExecution ✓ []object The scheduler will prefer to schedule pods to nodes that satisfy the affinity expressions specified by this field, but it may choose a node that violates one or more of the expressions. The node that is most preferred is the one with the greatest sum of weights, i.e. for each node that meets all of the scheduling requirements (resource request, requiredDuringScheduling affinity expressions, etc.), compute a sum by iterating through the elements of this field and adding “weight” to the sum if the node matches the corresponding matchExpressions; the node(s) with the highest sum are the most preferred.
    requiredDuringSchedulingIgnoredDuringExecution ✓ object A node selector represents the union of the results of one or more label queries over a set of nodes; that is, it represents the OR of the selectors represented by the node selector terms.
    SGDbOps.spec.scheduling.nodeAffinity.preferredDuringSchedulingIgnoredDuringExecution[index]

    ↩ Parent

    An empty preferred scheduling term matches all objects with implicit weight 0 (i.e. it’s a no-op). A null preferred scheduling term matches no objects (i.e. is also a no-op).

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    preference ✓ ✓ object A null or empty node selector term matches no objects. The requirements of them are ANDed. The TopologySelectorTerm type implements a subset of the NodeSelectorTerm.
    weight ✓ ✓ integer Weight associated with matching the corresponding nodeSelectorTerm, in the range 1-100.

    Format: int32
    SGDbOps.spec.scheduling.nodeAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].preference

    ↩ Parent

    A null or empty node selector term matches no objects. The requirements of them are ANDed. The TopologySelectorTerm type implements a subset of the NodeSelectorTerm.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object A list of node selector requirements by node’s labels.
    matchFields ✓ []object A list of node selector requirements by node’s fields.
    SGDbOps.spec.scheduling.nodeAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].preference.matchExpressions[index]

    ↩ Parent

    A node selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string The label key that the selector applies to.
    operator ✓ ✓ string Represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists, DoesNotExist. Gt, and Lt.
    values ✓ []string An array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. If the operator is Gt or Lt, the values array must have a single element, which will be interpreted as an integer. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.nodeAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].preference.matchFields[index]

    ↩ Parent

    A node selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string The label key that the selector applies to.
    operator ✓ ✓ string Represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists, DoesNotExist. Gt, and Lt.
    values ✓ []string An array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. If the operator is Gt or Lt, the values array must have a single element, which will be interpreted as an integer. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution

    ↩ Parent

    A node selector represents the union of the results of one or more label queries over a set of nodes; that is, it represents the OR of the selectors represented by the node selector terms.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    nodeSelectorTerms ✓ ✓ []object Required. A list of node selector terms. The terms are ORed.
    SGDbOps.spec.scheduling.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[index]

    ↩ Parent

    A null or empty node selector term matches no objects. The requirements of them are ANDed. The TopologySelectorTerm type implements a subset of the NodeSelectorTerm.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object A list of node selector requirements by node’s labels.
    matchFields ✓ []object A list of node selector requirements by node’s fields.
    SGDbOps.spec.scheduling.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[index].matchExpressions[index]

    ↩ Parent

    A node selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string The label key that the selector applies to.
    operator ✓ ✓ string Represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists, DoesNotExist. Gt, and Lt.
    values ✓ []string An array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. If the operator is Gt or Lt, the values array must have a single element, which will be interpreted as an integer. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.nodeAffinity.requiredDuringSchedulingIgnoredDuringExecution.nodeSelectorTerms[index].matchFields[index]

    ↩ Parent

    A node selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string The label key that the selector applies to.
    operator ✓ ✓ string Represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists, DoesNotExist. Gt, and Lt.
    values ✓ []string An array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. If the operator is Gt or Lt, the values array must have a single element, which will be interpreted as an integer. This array is replaced during a strategic merge patch.

    SGDbOps.spec.scheduling.podAffinity

    ↩ Parent

    Pod affinity is a group of inter pod affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#podaffinity-v1-core

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    preferredDuringSchedulingIgnoredDuringExecution ✓ []object The scheduler will prefer to schedule pods to nodes that satisfy the affinity expressions specified by this field, but it may choose a node that violates one or more of the expressions. The node that is most preferred is the one with the greatest sum of weights, i.e. for each node that meets all of the scheduling requirements (resource request, requiredDuringScheduling affinity expressions, etc.), compute a sum by iterating through the elements of this field and adding “weight” to the sum if the node has pods which matches the corresponding podAffinityTerm; the node(s) with the highest sum are the most preferred.
    requiredDuringSchedulingIgnoredDuringExecution ✓ []object If the affinity requirements specified by this field are not met at scheduling time, the pod will not be scheduled onto the node. If the affinity requirements specified by this field cease to be met at some point during pod execution (e.g. due to a pod label update), the system may or may not try to eventually evict the pod from its node. When there are multiple elements, the lists of nodes corresponding to each podAffinityTerm are intersected, i.e. all terms must be satisfied.
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index]

    ↩ Parent

    The weights of all of the matched WeightedPodAffinityTerm fields are added per-node to find the most preferred node(s)

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    podAffinityTerm ✓ ✓ object Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running
    weight ✓ ✓ integer weight associated with matching the corresponding podAffinityTerm, in the range 1-100.

    Format: int32
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm

    ↩ Parent

    Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    topologyKey ✓ ✓ string This pod should be co-located (affinity) or not co-located (anti-affinity) with the pods matching the labelSelector in the specified namespaces, where co-located is defined as running on a node whose value of the label with key topologyKey matches that of any node on which any of the selected pods is running. Empty topologyKey is not allowed.
    labelSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaceSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaces ✓ []string namespaces specifies a static list of namespace names that the term applies to. The term is applied to the union of the namespaces listed in this field and the ones selected by namespaceSelector. null or empty namespaces list and null namespaceSelector means “this pod’s namespace”.
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.labelSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.labelSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.namespaceSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.namespaceSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAffinity.requiredDuringSchedulingIgnoredDuringExecution[index]

    ↩ Parent

    Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    topologyKey ✓ ✓ string This pod should be co-located (affinity) or not co-located (anti-affinity) with the pods matching the labelSelector in the specified namespaces, where co-located is defined as running on a node whose value of the label with key topologyKey matches that of any node on which any of the selected pods is running. Empty topologyKey is not allowed.
    labelSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaceSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaces ✓ []string namespaces specifies a static list of namespace names that the term applies to. The term is applied to the union of the namespaces listed in this field and the ones selected by namespaceSelector. null or empty namespaces list and null namespaceSelector means “this pod’s namespace”.
    SGDbOps.spec.scheduling.podAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].labelSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].labelSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].namespaceSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].namespaceSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.

    SGDbOps.spec.scheduling.podAntiAffinity

    ↩ Parent

    Pod anti affinity is a group of inter pod anti affinity scheduling rules.

    See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#podantiaffinity-v1-core

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    preferredDuringSchedulingIgnoredDuringExecution ✓ []object The scheduler will prefer to schedule pods to nodes that satisfy the anti-affinity expressions specified by this field, but it may choose a node that violates one or more of the expressions. The node that is most preferred is the one with the greatest sum of weights, i.e. for each node that meets all of the scheduling requirements (resource request, requiredDuringScheduling anti-affinity expressions, etc.), compute a sum by iterating through the elements of this field and adding “weight” to the sum if the node has pods which matches the corresponding podAffinityTerm; the node(s) with the highest sum are the most preferred.
    requiredDuringSchedulingIgnoredDuringExecution ✓ []object If the anti-affinity requirements specified by this field are not met at scheduling time, the pod will not be scheduled onto the node. If the anti-affinity requirements specified by this field cease to be met at some point during pod execution (e.g. due to a pod label update), the system may or may not try to eventually evict the pod from its node. When there are multiple elements, the lists of nodes corresponding to each podAffinityTerm are intersected, i.e. all terms must be satisfied.
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index]

    ↩ Parent

    The weights of all of the matched WeightedPodAffinityTerm fields are added per-node to find the most preferred node(s)

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    podAffinityTerm ✓ ✓ object Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running
    weight ✓ ✓ integer weight associated with matching the corresponding podAffinityTerm, in the range 1-100.

    Format: int32
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm

    ↩ Parent

    Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    topologyKey ✓ ✓ string This pod should be co-located (affinity) or not co-located (anti-affinity) with the pods matching the labelSelector in the specified namespaces, where co-located is defined as running on a node whose value of the label with key topologyKey matches that of any node on which any of the selected pods is running. Empty topologyKey is not allowed.
    labelSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaceSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaces ✓ []string namespaces specifies a static list of namespace names that the term applies to. The term is applied to the union of the namespaces listed in this field and the ones selected by namespaceSelector. null or empty namespaces list and null namespaceSelector means “this pod’s namespace”.
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.labelSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.labelSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.namespaceSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAntiAffinity.preferredDuringSchedulingIgnoredDuringExecution[index].podAffinityTerm.namespaceSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAntiAffinity.requiredDuringSchedulingIgnoredDuringExecution[index]

    ↩ Parent

    Defines a set of pods (namely those matching the labelSelector relative to the given namespace(s)) that this pod should be co-located (affinity) or not co-located (anti-affinity) with, where co-located is defined as running on a node whose value of the label with key matches that of any node on which a pod of the set of pods is running

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    topologyKey ✓ ✓ string This pod should be co-located (affinity) or not co-located (anti-affinity) with the pods matching the labelSelector in the specified namespaces, where co-located is defined as running on a node whose value of the label with key topologyKey matches that of any node on which any of the selected pods is running. Empty topologyKey is not allowed.
    labelSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaceSelector ✓ object A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.
    namespaces ✓ []string namespaces specifies a static list of namespace names that the term applies to. The term is applied to the union of the namespaces listed in this field and the ones selected by namespaceSelector. null or empty namespaces list and null namespaceSelector means “this pod’s namespace”.
    SGDbOps.spec.scheduling.podAntiAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].labelSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAntiAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].labelSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.
    SGDbOps.spec.scheduling.podAntiAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].namespaceSelector

    ↩ Parent

    A label selector is a label query over a set of resources. The result of matchLabels and matchExpressions are ANDed. An empty label selector matches all objects. A null label selector matches no objects.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    matchExpressions ✓ []object matchExpressions is a list of label selector requirements. The requirements are ANDed.
    matchLabels ✓ map[string]string matchLabels is a map of {key,value} pairs. A single {key,value} in the matchLabels map is equivalent to an element of matchExpressions, whose key field is “key”, the operator is “In”, and the values array contains only “value”. The requirements are ANDed.
    SGDbOps.spec.scheduling.podAntiAffinity.requiredDuringSchedulingIgnoredDuringExecution[index].namespaceSelector.matchExpressions[index]

    ↩ Parent

    A label selector requirement is a selector that contains values, a key, and an operator that relates the key and values.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    key ✓ ✓ string key is the label key that the selector applies to.
    operator ✓ ✓ string operator represents a key’s relationship to a set of values. Valid operators are In, NotIn, Exists and DoesNotExist.
    values ✓ []string values is an array of string values. If the operator is In or NotIn, the values array must be non-empty. If the operator is Exists or DoesNotExist, the values array must be empty. This array is replaced during a strategic merge patch.

    SGDbOps.spec.scheduling.tolerations[index]

    ↩ Parent

    The pod this Toleration is attached to tolerates any taint that matches the triple <key,value,effect> using the matching operator .

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    effect ✓ string Effect indicates the taint effect to match. Empty means match all taint effects. When specified, allowed values are NoSchedule, PreferNoSchedule and NoExecute.
    key ✓ string Key is the taint key that the toleration applies to. Empty means match all taint keys. If the key is empty, operator must be Exists; this combination means to match all values and all keys.
    operator ✓ string Operator represents a key’s relationship to the value. Valid operators are Exists and Equal. Defaults to Equal. Exists is equivalent to wildcard for value, so that a pod can tolerate all taints of a particular category.
    tolerationSeconds ✓ integer TolerationSeconds represents the period of time the toleration (which must be of effect NoExecute, otherwise this field is ignored) tolerates the taint. By default, it is not set, which means tolerate the taint forever (do not evict). Zero and negative values will be treated as 0 (evict immediately) by the system.

    Format: int64
    value ✓ string Value is the taint value the toleration matches to. If the operator is Exists, the value should be empty, otherwise just a regular string.

    SGDbOps.spec.securityUpgrade

    ↩ Parent

    Configuration of security upgrade

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    method ✓ string The method used to perform the security upgrade operation. Available methods are:

    • InPlace: the in-place method does not require more resources than those that are available. In case only an instance of the StackGres cluster is present this mean the service disruption will last longer so we encourage use the reduced impact restart and especially for a production environment.
    • ReducedImpact: this procedure is the same as the in-place method but require additional resources in order to spawn a new updated replica that will be removed when the procedure completes.

    SGDbOps.spec.vacuum

    ↩ Parent

    Configuration of vacuum operation

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    analyze ✓ boolean If true, updates statistics used by the planner to determine the most efficient way to execute a query. Defaults to: true.
    databases ✓ []object List of databases to vacuum or repack, don’t specify to select all databases
    disablePageSkipping ✓ boolean Normally, VACUUM will skip pages based on the visibility map. Pages where all tuples are known to be frozen can always be skipped, and those where all tuples are known to be visible to all transactions may be skipped except when performing an aggressive vacuum. Furthermore, except when performing an aggressive vacuum, some pages may be skipped in order to avoid waiting for other sessions to finish using them. This option disables all page-skipping behavior, and is intended to be used only when the contents of the visibility map are suspect, which should happen only if there is a hardware or software issue causing database corruption. Defaults to: false.
    freeze ✓ boolean If true selects aggressive “freezing” of tuples. Specifying FREEZE is equivalent to performing VACUUM with the vacuum_freeze_min_age and vacuum_freeze_table_age parameters set to zero. Aggressive freezing is always performed when the table is rewritten, so this option is redundant when FULL is specified. Defaults to: false.
    full ✓ boolean If true selects “full” vacuum, which can reclaim more space, but takes much longer and exclusively locks the table. This method also requires extra disk space, since it writes a new copy of the table and doesn’t release the old copy until the operation is complete. Usually this should only be used when a significant amount of space needs to be reclaimed from within the table. Defaults to: false.

    SGDbOps.spec.vacuum.databases[index]

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    name ✓ ✓ string the name of the database
    analyze ✓ boolean If true, updates statistics used by the planner to determine the most efficient way to execute a query. Defaults to: true.
    disablePageSkipping ✓ boolean Normally, VACUUM will skip pages based on the visibility map. Pages where all tuples are known to be frozen can always be skipped, and those where all tuples are known to be visible to all transactions may be skipped except when performing an aggressive vacuum. Furthermore, except when performing an aggressive vacuum, some pages may be skipped in order to avoid waiting for other sessions to finish using them. This option disables all page-skipping behavior, and is intended to be used only when the contents of the visibility map are suspect, which should happen only if there is a hardware or software issue causing database corruption. Defaults to: false.
    freeze ✓ boolean If true selects aggressive “freezing” of tuples. Specifying FREEZE is equivalent to performing VACUUM with the vacuum_freeze_min_age and vacuum_freeze_table_age parameters set to zero. Aggressive freezing is always performed when the table is rewritten, so this option is redundant when FULL is specified. Defaults to: false.
    full ✓ boolean If true selects “full” vacuum, which can reclaim more space, but takes much longer and exclusively locks the table. This method also requires extra disk space, since it writes a new copy of the table and doesn’t release the old copy until the operation is complete. Usually this should only be used when a significant amount of space needs to be reclaimed from within the table. Defaults to: false.

    SGDbOps.status

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    benchmark ✓ object The results of the benchmark
    conditions ✓ []object Possible conditions are:

    • Running: to indicate when the operation is actually running
    • Completed: to indicate when the operation has completed successfully
    • Failed: to indicate when the operation has failed
    majorVersionUpgrade ✓ object The results of a major version upgrade
    minorVersionUpgrade ✓ object The results of a minor version upgrade
    opRetries ✓ integer The number of retries performed by the operation
    opStarted ✓ string The ISO 8601 timestamp of when the operation started running
    restart ✓ object The results of a restart
    securityUpgrade ✓ object The results of a security upgrade

    SGDbOps.status.benchmark

    ↩ Parent

    The results of the benchmark

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    pgbench ✓ object The results of the pgbench benchmark

    SGDbOps.status.benchmark.pgbench

    ↩ Parent

    The results of the pgbench benchmark

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    latency ✓ object The latency results of the pgbench benchmark
    scaleFactor ✓ number The scale factor used to run pgbench (--scale).
    transactionsPerSecond ✓ object All the transactions per second results of the pgbench benchmark
    transactionsProcessed ✓ integer The number of transactions processed.
    SGDbOps.status.benchmark.pgbench.latency

    ↩ Parent

    The latency results of the pgbench benchmark

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    average ✓ object Average latency of transactions
    standardDeviation ✓ object The latency standard deviation of transactions.
    SGDbOps.status.benchmark.pgbench.latency.average

    ↩ Parent

    Average latency of transactions

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    unit ✓ string The latency measure unit represented in milliseconds
    value ✓ number The latency average value
    SGDbOps.status.benchmark.pgbench.latency.standardDeviation

    ↩ Parent

    The latency standard deviation of transactions.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    unit ✓ string The latency measure unit represented in milliseconds
    value ✓ number The latency standard deviation value
    SGDbOps.status.benchmark.pgbench.transactionsPerSecond

    ↩ Parent

    All the transactions per second results of the pgbench benchmark

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    excludingConnectionsEstablishing ✓ object Number of Transaction Per Second (tps) excluding connection establishing.
    includingConnectionsEstablishing ✓ object Number of Transaction Per Second (tps) including connection establishing.
    SGDbOps.status.benchmark.pgbench.transactionsPerSecond.excludingConnectionsEstablishing

    ↩ Parent

    Number of Transaction Per Second (tps) excluding connection establishing.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    unit ✓ string Transaction Per Second (tps) measure
    value ✓ number The Transaction Per Second (tps) excluding connections establishing value
    SGDbOps.status.benchmark.pgbench.transactionsPerSecond.includingConnectionsEstablishing

    ↩ Parent

    Number of Transaction Per Second (tps) including connection establishing.

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    unit ✓ string Transaction Per Second (tps) measure
    value ✓ number The Transaction Per Second (tps) including connections establishing value

    SGDbOps.status.conditions[index]

    ↩ Parent

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    lastTransitionTime ✓ string Last time the condition transitioned from one status to another.
    message ✓ string A human-readable message indicating details about the transition.
    reason ✓ string The reason for the condition last transition.
    status ✓ string Status of the condition, one of True, False or Unknown.
    type ✓ string Type of deployment condition.

    SGDbOps.status.majorVersionUpgrade

    ↩ Parent

    The results of a major version upgrade

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    failure ✓ string A failure message (when available)
    initialInstances ✓ []string The instances present when the operation started
    pendingToRestartInstances ✓ []string The instances that are pending to be restarted
    phase ✓ string The phase the operation is or was executing)
    primaryInstance ✓ string The primary instance when the operation started
    restartedInstances ✓ []string The instances that have been restarted
    sourcePostgresVersion ✓ string The postgres version currently used by the primary instance
    targetPostgresVersion ✓ string The postgres version that the cluster will be upgraded to

    SGDbOps.status.minorVersionUpgrade

    ↩ Parent

    The results of a minor version upgrade

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    failure ✓ string A failure message (when available)
    initialInstances ✓ []string The instances present when the operation started
    pendingToRestartInstances ✓ []string The instances that are pending to be restarted
    primaryInstance ✓ string The primary instance when the operation started
    restartedInstances ✓ []string The instances that have been restarted
    sourcePostgresVersion ✓ string The postgres version currently used by the primary instance
    switchoverFinalized ✓ string An ISO 8601 date indicating if and when the switchover finalized
    switchoverInitiated ✓ string An ISO 8601 date indicating if and when the switchover initiated
    targetPostgresVersion ✓ string The postgres version that the cluster will be upgraded (or downgraded) to

    SGDbOps.status.restart

    ↩ Parent

    The results of a restart

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    failure ✓ string A failure message (when available)
    initialInstances ✓ []string The instances present when the operation started
    pendingToRestartInstances ✓ []string The instances that are pending to be restarted
    primaryInstance ✓ string The primary instance when the operation started
    restartedInstances ✓ []string The instances that have been restarted
    switchoverFinalized ✓ string An ISO 8601 date indicating if and when the switchover finalized
    switchoverInitiated ✓ string An ISO 8601 date indicating if and when the switchover initiated

    SGDbOps.status.securityUpgrade

    ↩ Parent

    The results of a security upgrade

    Property
    Required
    Updatable
    May Require Restart
    Type
    		 Description

    Workaround for hugo bug not rendering first table row

    failure ✓ string A failure message (when available)
    initialInstances ✓ []string The instances present when the operation started
    pendingToRestartInstances ✓ []string The instances that are pending to be restarted
    primaryInstance ✓ string The primary instance when the operation started
    restartedInstances ✓ []string The instances that have been restarted
    switchoverFinalized ✓ string An ISO 8601 date indicating if and when the switchover finalized
    switchoverInitiated ✓ string An ISO 8601 date indicating if and when the switchover initiated