Labels and annotations v1

Suggest edits

Resources in Kubernetes are organized in a flat structure, with no hierarchical information or relationship between them. However, such resources and objects can be linked together and put in relationship through labels and annotations.

Info

For more information, please refer to the Kubernetes documentation on annotations and labels.

In short:

  • an annotation is used to assign additional non-identifying information to resources with the goal to facilitate integration with external tools
  • a label is used to group objects and query them through Kubernetes' native selector capability

You can select one or more labels and/or annotations you will use in your EDB Postgres for Kubernetes deployments. Then you need to configure the operator so that when you define these labels and/or annotations in a cluster's metadata, they are automatically inherited by all resources created by it (including pods).

Note

Label and annotation inheritance is the technique adopted by EDB Postgres for Kubernetes in lieu of alternative approaches such as pod templates.

Predefined labels

Below is a list of predefined labels that are managed by EDB Postgres for Kubernetes.

k8s.enterprisedb.io/backupName : Backup identifier, only available on Backup and VolumeSnapshot resources

k8s.enterprisedb.io/cluster : Name of the cluster

k8s.enterprisedb.io/immediateBackup : Applied to a Backup resource if the backup is the first one created from a ScheduledBackup object having immediate set to true.

k8s.enterprisedb.io/instanceName : Name of the PostgreSQL instance - this label replaces the old and deprecated postgresql label

k8s.enterprisedb.io/jobRole : Role of the job (i.e. import, initdb, join, ...)

k8s.enterprisedb.io/podRole : Currently fixed to instance to identify a pod running PostgreSQL

k8s.enterprisedb.io/poolerName : Name of the PgBouncer pooler

k8s.enterprisedb.io/pvcRole : Purpose of the PVC, such as PG_DATA or PG_WAL

k8s.enterprisedb.io/reload : Available on ConfigMap and Secret resources. When set to true, a change in the resource will be automatically reloaded by the operator.

k8s.enterprisedb.io/scheduled-backup : When available, name of the ScheduledBackup resource that created a given Backup object

role : Whether the instance running in a pod is a primary or a replica

k8s.enterprisedb.io/backupTimeline : The timeline of the instance when a backup was taken

k8s.enterprisedb.io/backupYear : The year a backup was taken

k8s.enterprisedb.io/backupMonth : The year/month when a backup was taken

k8s.enterprisedb.io/backupDate : The date in ISO 8601 format (YYYYMMDD) of the backup

k8s.enterprisedb.io/onlineBackup : Whether the backup is online (hot) or cold (taken when Postgres is down)

Predefined annotations

Below is a list of predefined annotations that are managed by EDB Postgres for Kubernetes.

container.apparmor.security.beta.kubernetes.io/* : Name of the AppArmor profile to apply to the named container. See AppArmor documentation for details

k8s.enterprisedb.io/coredumpFilter : Filter to control the coredump of Postgres processes, expressed with a bitmask. By default it is set to 0x31 in order to exclude shared memory segments from the dump. Please refer to "PostgreSQL core dumps" for more information.

k8s.enterprisedb.io/clusterManifest : Manifest of the Cluster owning this resource (such as a PVC) - this label replaces the old and deprecated k8s.enterprisedb.io/hibernateClusterManifest label

k8s.enterprisedb.io/fencedInstances : List, expressed in JSON format, of the instances that need to be fenced. The whole cluster is fenced if the list contains the * element.

k8s.enterprisedb.io/forceLegacyBackup : Applied to a Cluster resource for testing purposes only, in order to simulate the behavior of barman-cloud-backup prior to version 3.4 (Jan 2023) when the --name option was not available.

k8s.enterprisedb.io/hash : The hash value of the resource

k8s.enterprisedb.io/hibernation : Applied to a Cluster resource to control the declarative hibernation feature. Allowed values are on and off.

k8s.enterprisedb.io/managedSecrets : Pull secrets managed by the operator and automatically set in the ServiceAccount resources for each Postgres cluster

k8s.enterprisedb.io/nodeSerial : On a pod resource, identifies the serial number of the instance within the Postgres cluster

k8s.enterprisedb.io/operatorVersion : Version of the operator

k8s.enterprisedb.io/pgControldata : Output of the pg_controldata command - this annotation replaces the old and deprecated k8s.enterprisedb.io/hibernatePgControlData annotation

k8s.enterprisedb.io/podEnvHash : Deprecated as the k8s.enterprisedb.io/podSpec annotation now also contains the pod environment

k8s.enterprisedb.io/podSpec : Snapshot of the spec of the Pod generated by the operator - this annotation replaces the old and deprecated k8s.enterprisedb.io/podEnvHash annotation

k8s.enterprisedb.io/poolerSpecHash : Hash of the pooler resource

k8s.enterprisedb.io/pvcStatus : Current status of the pvc, one of initializing, ready, detached

k8s.enterprisedb.io/reconciliationLoop : When set to disabled on a Cluster, the operator prevents the reconciliation loop from running

k8s.enterprisedb.io/reloadedAt : Contains the latest cluster reload time, reload is triggered by user through plugin

k8s.enterprisedb.io/skipEmptyWalArchiveCheck : When set to true on a Cluster resource, the operator disables the check that ensures that the WAL archive is empty before writing data. Use at your own risk.

k8s.enterprisedb.io/backupStartWAL : The WAL at the start of a backup

k8s.enterprisedb.io/backupEndWAL : The WAL at the conclusion of a backup

k8s.enterprisedb.io/backupStartTime : The time a backup started

k8s.enterprisedb.io/backupEndTime : The time a backup ended

k8s.enterprisedb.io/snapshotStartTime : The time a snapshot started

k8s.enterprisedb.io/snapshotEndTime : The time a snapshot was marked as ready to use

kubectl.kubernetes.io/restartedAt : When available, the time of last requested restart of a Postgres cluster

Pre-requisites

By default, no label or annotation defined in the cluster's metadata is inherited by the associated resources. In order to enable label/annotation inheritance, you need to follow the instructions provided in the "Operator configuration" section.

Below we will continue on that example and limit it to the following:

  • annotations: categories
  • labels: app, environment, and workload
Note

Feel free to select the names that most suit your context for both annotations and labels. Remember that you can also use wildcards in naming and adopt strategies like mycompany/* for all labels or annotations starting with mycompany/ to be inherited.

Defining cluster's metadata

When defining the cluster, before any resource is deployed, you can properly set the metadata as follows:

apiVersion: postgresql.k8s.enterprisedb.io/v1
kind: Cluster
metadata:
  name: cluster-example
  annotations:
    categories: database
  labels:
    environment: production
    workload: database
    app: sso
spec:
     # ... <snip>

Once the cluster is deployed, you can verify, for example, that the labels have been correctly set in the pods with:

kubectl get pods --show-labels

Current limitations

Currently, EDB Postgres for Kubernetes does not automatically propagate labels or annotations deletions. Therefore, when an annotation or label is removed from a Cluster, which was previously propagated to the underlying pods, the operator will not automatically remove it on the associated resources.