PostgresCluster
PostgresCluster
PostgresCluster is the Schema for the postgresclusters API
name | type | required | description |
---|---|---|---|
apiVersion | string | ✅ | APIVersion defines the versioned schema of this representation of an object. Servers should convert recognized schemas to the latest internal value, and may reject unrecognized values. More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#resources |
kind | string | ✅ | Kind is a string value representing the REST resource this object represents. Servers may infer this from the endpoint the client submits requests to. Cannot be updated. In CamelCase. More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#types-kinds |
metadata | object | ✅ | Refer to the Kubernetes API documentation for the fields of the metadata field. |
spec | object | ❌ | PostgresClusterSpec defines the desired state of PostgresCluster |
status | object | ❌ | PostgresClusterStatus defines the observed state of PostgresCluster |
↩ ParentPostgresCluster.spec
PostgresClusterSpec defines the desired state of PostgresCluster
name | type | required | description |
---|---|---|---|
backups | object | ✅ | PostgreSQL backup configuration |
customReplicationTLSSecret | object | ❌ | The secret containing the replication client certificates and keys for secure connections to the PostgreSQL server. It will need to contain the client TLS certificate, TLS key and the Certificate Authority certificate with the data keys set to tls.crt, tls.key and ca.crt, respectively. NOTE: If CustomReplicationClientTLSSecret is provided, CustomTLSSecret MUST be provided and the ca.crt provided must be the same. |
customTLSSecret | object | ❌ | The secret containing the Certificates and Keys to encrypt PostgreSQL traffic will need to contain the server TLS certificate, TLS key and the Certificate Authority certificate with the data keys set to tls.crt, tls.key and ca.crt, respectively. It will then be mounted as a volume projection to the '/pgconf/tls' directory. For more information on Kubernetes secret projections, please see https://k8s.io/docs/concepts/configuration/secret/#projection-of-secret-keys-to-specific-paths NOTE: If CustomTLSSecret is provided, CustomReplicationClientTLSSecret MUST be provided and the ca.crt provided must be the same. |
dataSource | object | ❌ | Specifies a data source for bootstrapping the PostgreSQL cluster. |
databaseInitSQL | object | ❌ | DatabaseInitSQL defines a ConfigMap containing custom SQL that will be run after the cluster is initialized. This ConfigMap must be in the same namespace as the cluster. |
disableDefaultPodScheduling | boolean | ❌ | Whether or not the PostgreSQL cluster should use the defined default scheduling constraints. If the field is unset or false, the default scheduling constraints will be used in addition to any custom constraints provided. |
image | string | ❌ | The image name to use for PostgreSQL containers. When omitted, the value comes from an operator environment variable. For standard PostgreSQL images, the format is RELATED_IMAGE_POSTGRES_{postgresVersion} , e.g. RELATED_IMAGE_POSTGRES_13. For PostGIS enabled PostgreSQL images, the format is RELATED_IMAGE_POSTGRES_{postgresVersion} GIS{postGISVersion} , e.g. RELATED_IMAGE_POSTGRES_13_GIS_3.1. |
imagePullPolicy | Always , Never , IfNotPresent | ❌ | ImagePullPolicy is used to determine when Kubernetes will attempt to pull (download) container images. More info: https://kubernetes.io/docs/concepts/containers/images/#image-pull-policy |
imagePullSecrets | []object | ❌ | The image pull secrets used to pull from a private registry Changing this value causes all running pods to restart. https://k8s.io/docs/tasks/configure-pod-container/pull-image-private-registry/ |
instances | []object | ✅ | Specifies one or more sets of PostgreSQL pods that replicate data for this cluster. |
metadata | object | ❌ | Metadata contains metadata for PostgresCluster resources |
monitoring | object | ❌ | The specification of monitoring tools that connect to PostgreSQL |
openshift | boolean | ❌ | Whether or not the PostgreSQL cluster is being deployed to an OpenShift environment. If the field is unset, the operator will automatically detect the environment. |
patroni | object | ❌ | undefined |
port | integer | ❌ | The port on which PostgreSQL should listen. |
postGISVersion | string | ❌ | The PostGIS extension version installed in the PostgreSQL image. When image is not set, indicates a PostGIS enabled image will be used. |
postgresVersion | integer | ✅ | The major version of PostgreSQL installed in the PostgreSQL image |
proxy | object | ❌ | The specification of a proxy that connects to PostgreSQL. |
service | object | ❌ | Specification of the service that exposes the PostgreSQL primary instance. |
shutdown | boolean | ❌ | Whether or not the PostgreSQL cluster should be stopped. When this is true, workloads are scaled to zero and CronJobs are suspended. Other resources, such as Services and Volumes, remain in place. |
standby | object | ❌ | Run this cluster as a read-only copy of an existing cluster or archive. |
supplementalGroups | []integer | ❌ | A list of group IDs applied to the process of a container. These can be useful when accessing shared file systems with constrained permissions. More info: https://kubernetes.io/docs/reference/kubernetes-api/workload-resources/pod-v1/#security-context |
users | []object | ❌ | Users to create inside PostgreSQL and the databases they should access. The default creates one user that can access one database matching the PostgresCluster name. An empty list creates no users. Removing a user from this list does NOT drop the user nor revoke their access. |
↩ ParentPostgresCluster.spec.backups
PostgreSQL backup configuration
name | type | required | description |
---|---|---|---|
pgbackrest | object | ✅ | pgBackRest archive configuration |
↩ ParentPostgresCluster.spec.backups.pgbackrest
pgBackRest archive configuration
name | type | required | description |
---|---|---|---|
configuration | []object | ❌ | Projected volumes containing custom pgBackRest configuration. These files are mounted under "/etc/pgbackrest/conf.d" alongside any pgBackRest configuration generated by the PostgreSQL Operator: https://pgbackrest.org/configuration.html |
global | map[string]: string | ❌ | Global pgBackRest configuration settings. These settings are included in the "global" section of the pgBackRest configuration generated by the PostgreSQL Operator, and then mounted under "/etc/pgbackrest/conf.d": https://pgbackrest.org/configuration.html |
image | string | ❌ | The image name to use for pgBackRest containers. Utilized to run pgBackRest repository hosts and backups. The image may also be set using the RELATED_IMAGE_PGBACKREST environment variable |
jobs | object | ❌ | Jobs field allows configuration for all backup jobs |
manual | object | ❌ | Defines details for manual pgBackRest backup Jobs |
metadata | object | ❌ | Metadata contains metadata for PostgresCluster resources |
repoHost | object | ❌ | Defines configuration for a pgBackRest dedicated repository host. This section is only applicable if at least one "volume" (i.e. PVC-based) repository is defined in the "repos" section, therefore enabling a dedicated repository host Deployment. |
repos | []object | ✅ | Defines a pgBackRest repository |
restore | object | ❌ | Defines details for performing an in-place restore using pgBackRest |
sidecars | object |