General Characteristics – genc
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
instm | Installation mechanism | string_array | Mechanism(s) provided to install the operator. | Provide a succinct value or list of values of the supported mechanisms. If any of the following names apply, use them, and add other mechanism names, as needed: * YAML * Helm * Kustomize * Operator Bundle |
✓ |
mcrds | Management via CRDs | boolean | The operator manages CRDs (Custom Resource Definition). | If true, provide a list of the names of the CRDs managed by the operator. Names should be direct links to their documentation or API reference. |
✓ |
offin | Offline installation | boolean | Whether it is possible to install the operator on a (air-gapped) cluster without internet connection. | A link should be provided with documentation on how to install the operator on air-gapped environments. |
|
scpua | Supported CPU architectures | string_array | Support for the operator to run on nodes with specified CPU architectures. | Provide a list of CPU architectures that are supported between: * amd64 * arm * arm64 * ppc64le * s390x In case you support additional architectures, add their name(s) in a similar fashion. |
|
coios | Container images OSes | string_array | Indicate the base image of the images used by the operator. (e.g: scratch, ubi, fedora, ubuntu, centos, alpine, etc.). Provide the image name without tags (e.g. debian instead of debian:8.11). |
||
olmcl | Operator Capability Level | string | Operator Capability Levels indicates the operator maturity levels in regards to their lifecycle management capabilities for the application or workload they deliver. The capability models aims to provide guidance in terminology to express what features users can expect from an operator. |
Capability level must be set to one of the following levels: 1. Basic Install 2. Seamless Upgrades 3. Full Lifecycle 4. Deep Insights 5. Auto Pilot A link should be provided with documentation on how the operator fulfil the declared capability level. For a detailed description of each capability level refer to the Operator Framework documentation for Operator Capability Level. |
Versions – vers
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
pgver | Supported PostgreSQL versions | string_array | Which major (and minor) versions does this version of the operator support. | Provide a list of every supported major version followed by a list in parenthesis of the minor versions supported for that major version. E.g. '15 (15.1, 15.0), 14 (14.3, 14.2)'. All versions must be ordered by reverse chronological order. Other components versions that are used may be described in the comments (e.g: Patroni, WAL-G, PgBackRest, PgBouncer, etc.) |
✓ |
k8ver | Supported Kubernetes versions | string_array | Which Kubernetes versions the operator can be installed into. | Provide a list of official Kubernetes minor versions numbers, ordered by reverse chronological order. Use a range of versions, if possible, e.g. '1.26 - 1.23' or '1.22 - 1.19'. |
✓ |
pgfor | PostgreSQL OSS forks | string_array | PostgreSQL forks are considered derived projects that started from PostgreSQL codebase and add different features while maintaining compatibility with PostgreSQL. Some operators may provide support for some of such forks, alongside with the original PostgreSQL. |
Leave empty if no version other than the original PostgreSQL is supported. Otherwise, provide a list of names and links to the PostgreSQL forks supported. If non-OSS forks are supported, leave empty but add a link to them in the comments section. |
Licensing & Support – lisu
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
ossli | Open Source license | boolean | The operator is published, and its source code is made publicly available, under an OSI-approved open source license. | If true, provide the SPDX identifier(s) of the license. |
✓ |
fcimg | Free container images | boolean | The container images used for the operator's operation are free to distribute and use, not subject to commercial restrictions. | If false, provide a link with documentation on the usage requisites/restrictions of the container images. |
✓ |
nenof | No enterprise-only features | boolean | All the operator's features are provided as open source. No derived, proprietary (often called 'enterprise') versions exist with additional, non open source features. |
If false, provide links to all known derived, proprietary versions. Linked documentation should clearly reflect the features that are only part of proprietary versions. |
|
comms | Commercial support | boolean | Vendor and/or other entities offer paid-for, commercial support for the operator. | Provide a link or list of links to the entities that provide commercial support. Links should be as specific as possible, pointing to informative documentation on the provided support. |
|
pubit | Public issue tracker | boolean | Development happens in the open. There is a public issue tracker where users may view, comment and create issues. | Provide a specific link to the issue tracker. |
|
pubch | Public chat/forums | boolean | There is/are public forums, mailing lists, chat groups (Slack, Discord, Matrix, etc) where users may freely join and participate in discussions. | Provide links to all relevant user forums. |
PostgreSQL Clusters – pgcl
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
depau | Deployment automation | boolean | The operator provides capabilities to automatically deploy production-ready clusters based on a provided configuration. No user initiated commands must be required. |
||
pomte | Pod management technology | string | Which Pod management technology is used to handle database's Pods. E.g. 'StatefulSet', 'Deployment', 'Custom', etc. | Provide the most succinct possible name of the technology. Use the Kubernetes resource type name (e.g. 'Deployment'), if applicable. |
✓ |
pgcnf | PostgreSQL custom config | boolean | The operator allows the user to supply custom PostgreSQL configuration. | ||
conpl | Integrated connection pooling | boolean | The operator provides options to deploy a connection pool in front of the database, automatically deployed and configured. | The connection pool may be deployed in several ways, like a Deployment layer, a side car, etc. All should be valid towards this feature as long as they are deployed automatically and offer an entrypoint for the user to the connection pooler. |
✓ |
cpccf | Connection pool custom config | boolean | The operator allows the user to supply a custom connection pool configuration for the connection pool service. | Only applies if [pgcl/conpl] is true. |
|
tlssp | TLS Support | boolean | PostgreSQL connections can be secured with Postgres SSL/TLS support. | ✓ | |
tlscu | TLS user-provided certificates | boolean | Operators may chose by default to generate self-signed SSL certificates. They may also offer the option to specify the CA and certificates that users want Postgres clusters to use. |
||
crtmg | CertManager integration | boolean | The operator integrates with CertManager in order to generate the certificate to be used with Postgres. | Only applies if [pgcl/tlscu] is true. |
|
insql | Initialization from SQL scripts | boolean | After the database cluster creation, the operator will run automatically one or more user-supplied scripts for initial DDL or data (possibly limited in size) creation. The operator must properly inform the user of the execution result of the scripts. |
||
inext | Initialization from external source | boolean | After the database cluster creation, the operator will automatically connect to an external data source (like an object storage or a public repo) and fetch the DDL/data. The operator must properly inform the user of the execution result of the scripts. |
||
cuhba | HBA custom config | boolean | The operator allows users to provide custom configuration for the Postgres HBA (Host-Based Authentication) mechanism. It may involve directly generating the custom pg_hba.conf file or by using more cloud-native technologies. |
||
mgmup | Management of db users/passwords | boolean | The operator provides a mechanism to declaratively create, modify or delete users, roles and/or password for the PostgreSQL cluster. | ||
reqli | Customize computing resource requests, limits | boolean | The user may specify/customize the requests, the limits or both for computing resources (CPU, memory) of the Postgres pods. | ✓ | |
hugpa | Support for huge pages | boolean | The user may specify the request to use huge pages for Postgres (and/or potentially other sidecars). Postgres must be able to be configured and start using huge pages. |
✓ | |
pgsrv | PostgreSQL exposed via Service | string | The operator creates by default or allows the user to request one or more Kubernetes Service(s) to be created to expose the PostgreSQL connections. Expected capabilities should include a RW (read-write) or RO (read-only in case of cascading replication) connection to the primary instance; and, optionally, a RO (read-only) to load balance read-only replicas instances in the cluster. |
The value must be one of: * PrimaryAndReplicas: Primary and replicas services must be offered. * PrimaryAndReplicasAndBalanced: Primary service, replicas services and a service that load balance RW/RO traffic transparently must be offered. * Balanced: A single service that load balances RW/RO traffic transparently. * Primary: Primary service must be offered. |
|
stosc | Automatic storage scaling | boolean | If the user's selected storage technology supports transparent scaling, the operator will take care of scaling the storage automatically (either by setting some default thresholds or requiring explicit declarative configuration from the user). |
||
scal0 | Scale down to zero | boolean | The number of pods in the cluster can be set to 0. This implies that no pods (no compute) would be used, but storage is not removed. Upon scaling up, the cluster should be brought back up without the need to restore a backup. This feature may also be known as "hibernation". |
||
tblsp | Tablespaces | boolean | The user may specify one or more PostgreSQL tablespaces and their associated backing storage. | ||
cupgi | Custom Postgres images | boolean | The operator allows the user to specify custom (user-provided) Postgres container images, instead of using the operator's provided images. | The operator should specify if the custom image needs to follow some minimal patterns to be able to work, or if it can work with any postgres container image provided. |
|
uside | User supplied sidecars | boolean | The user may specify custom sidecars (containers or init containers) to be created alongside the Postgres container (and, possibly, other operator sidecars). User supplied sidecars must be able, by default or by configuration, to access the Postgres container filesystem and Unix Domain Sockets file. |
||
usvol | User supplied volumes | boolean | The user may specify and mount custom volumes to be created alongside the volumes created for the Postgres container. | ||
usprt | User supplied ports | boolean | The user may specify custom ports to be created alongside the services that expose PostgreSQL. | Only applies if [pgcl/pgsrv] is set. |
|
srvbi | Support for Service Binding | boolean | Service Binding is a Kubernetes specification to "communicating service secrets to workloads in a consistent way". If the operator supports Service Binding, applications that are bound to the Postgres clusters will be able to fetch database access credentials without requiring the user to specify them manually in the application. |
The operator must implement the Provisioned Service part of the specification. |
|
cuann | Custom Annotations | boolean | The operator allows the user to provide custom Annotations (aside from any operator generated Annotations) to the objects generated by the operator. |
The operator must provide configuration for setting Annotations on all objects generated by the operator. Partial compliance is achieved if at least Pods can be annotated and this is clearly marked in the comments. |
|
culab | Custom Labels | boolean | The operator allows the user to provide custom Labels to the objects generated by the operator. | The operator must provide configuration for setting Labels on all objects generated by the operator. Partial compliance is achieved if at Labels can be added to at least Pods and this is clearly marked in the comments. |
|
apdnd | Assign Pod to Node | string | The operator allows Postgres Pods to be assigned to a specific set of Nodes based on some Kubernetes known rules. E.g. Node Labels, Affinity, etc. | Indicate one of the following values: * 'Complete': if the operator support all the rules to assign a Pod to a Node defined in the latest Kubernetes version specified under [vers/k8ver]. * 'Partial': if the operator support only partially the rules to assign a Pod to a Node. A link for each supported rule or rules group to assign a Pod to a Node must be specified. |
|
topsc | Topology Spread Constraints | boolean | The operator allows Postgres pods to specify Topology Spread Constraints, to control how Pods are spread across the Kubernetes cluster among failure-domains such as regions, zones, nodes, and other user-defined topology domains. |
HA & Replication – harp
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
autfa | Automated failover | boolean | The operator provides the facility that in the event of a node or pod failure where the Postgres primary is affected, another Postgres instance (if available) will be promoted to primary. The operation must happen automatically without user intervention. |
✓ | |
techa | HA Technology | string | The technology (software name or technology principles) that support the high availability and automated failover capabilities of the operator. | Provide a succinct software or technology name. E.g.: Patroni, Stolon, Custom. |
✓ |
asrep | Asynchronous replication | boolean | The operator allows to configure Postgres clusters using asynchronous streaming replication. Asynchronous is the default streaming replication mode in Postgres. |
||
syrep | Synchronous replication | boolean | The operator allows to configure Postgres clusters using synchronous streaming replication. The operator must manage the configuration details based on the user's preferences on which nodes behave synchronously. |
||
serep | Semi-synchronous replication | boolean | Semi-synchronous, or also called group or quorum replication, is a hybrid mode where a subset of the nodes is expected to replicate synchronously; and once that level is reached, the remainding nodes replicate asynchronously. That is, Postgres waits for confirmation of the write only from the synchronous nodes before considering the transaction committed. |
||
derep | Delayed replicas | boolean | The operator allows the user to configure one or more replicas subject to a user-specified (intentional) replication lag. This is useful to have always an online instance with data "in the past" for analytics or data recovery purposes. |
||
carep | Cascading replication | boolean | Postgres allows to create replicas that are fed from another replica, instead of replicating from the primary instance. This is interesting to alleviate the effects of replication on the primary; and allows to create arbitrary replication tree-like topologies. |
||
exrep | Replication from external origin | boolean | The operator allows a Postgres cluster to be setup in recovery mode while replicating from an external (non-operator managed) Postgres origin. This allows migrations to the operator using streaming replication. |
To implement the feature, the user should be able to provide arbitrary host, port, username and password (or other means of credential passing) of the origin. |
|
walsh | WAL Shipping | boolean | WAL Shipping is a Postgres technique that allows replication via a shared storage mechanism where WAL files produced on the primary node are copied ("shipped") to the replica. This feature is useful for having replicas for example on DR sites, replicate over global storage object stores and others. |
Implementing the feature implies both generating WAL files to a suitable location; as well as creating clusters that permanently read those WAL files and replicate from them. |
|
prstb | Promote standby cluster | boolean | The operator allows the user to promote a standby cluster that is a cluster with primary in recovery mode so that the primary becomes RW. This feature is used in conjunction with [harp/exrep] and/or [harp/walsh] to make GEO-replicated and/or DR (Disaster Recovery) clusters on other regions, where a region is essentially an independent Kubernetes cluster. | Only applies if [harp/exrep] or [harp/walsh] are true. The operator must allow to promote a standby clusters replicating either via WAL Shipping and/or streaming replication. |
✓ |
lorep | Managed logical replication | boolean | Postgres supports logical replication as well as streaming replication. It requires some configuration and commands to be run by the user. This feature represents operator capabilities to perform these operations in a managed way, without the user having to type commands or create configurations directly. |
The operator is considered compliant if it allows the user to provide logical replication without having to setup it directly, just specifying (declarative) preferences. The operator is still considered compliant if it cannot proceed until certain operations are performed by the users that are dependent on their environment (e.g. adding PKs, UNIQUEs or REPLICA IDENTITY to the DDL). |
PostgreSQL Extensions – pgex
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
extme | Extensions distribution mechanism | string | This feature is set to describe how extensions are shipped in a containerized environment. Typically they are part of the same Postgres container image, but they may also be distributed via other mechanisms. |
Indicate 'built-in' if the extensions come included with the same Postgres container; or a succinct word or few words naming the distribution mechanism. More details may be provided, if needed, via the links and comments fields. |
|
coext | Core/contrib extensions | integer | The number of core+contrib extensions provided by the operator for the latest Postgres version provided by the operator. | Submission must provide the total number of core+contrib extensions supported for the latest Postgres version provided by the operator. It should also be provided, when available, a link with a detailed list of those extensions supported (via links field). |
✓ |
thext | Third-party extensions | integer | The number of extensions not included in the Postgres core+contrib (i.e. created by third parties, outside of Postgres repository) for the latest Postgres version provided by the operator. | Submission must provide the total number of third-party extensions supported for the latest Postgres version provided by the operator. A link with a detailed list of those extensions supported (via links field) should also be provided, if available. |
✓ |
byext | Bring your own extension | boolean | The operator provides mechanisms for users to add (or upload) third-party extensions not initially provided by the operator. | The operator must support providing some mechanism to include custom extensions additionally or independently of the extension distribution mechanism, if a user builds a local extension, this could be uploaded or included on the postgres container with an automatic copy to all replicas related. |
Backups – bkup
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
bktch | Backup Technology | string | What technology (pgbasebackup, PgBackRest, WAL-e/g, Barman, custom, etc) is used to support creation and restoration of backups. | Provide the most succinct possible name of the technology. |
✓ |
bkdst | Backup destinations | string_array | Where backups can be stored (typically this may include object stores, PVs, etc). | If any of the following technology names apply, use them, and add other names, as needed: * PersistentVolume * NFS * S3 * GCS * Azure Blob * Local file system |
|
autbk | Automated backup management | boolean | The operator provides mechanisms for performing backups automatically and providing lifecycle mechanisms (delete old backups according to a user-supplied policy - often known as retention policies). | True response for the feature implies both automatic backups and lifecycle management. If only the former is provided, answer should be false but this capability should be mentioned in the comments field. |
✓ |
encbk | Backups encryption | boolean | Backups can be performed with user-supplied encryption keys. | ||
ptrbk | Point In Time Recovery | boolean | The operator provides support for the user to specify a recovery point (in the past) to which a backup should be recovered to (if unspecified, backup will be recovered in full). |
True response implies that at least time-based recovery is supported. If the operator also supports PITR by xid and label, clarify in the comments field. |
|
mulbk | Multiple backup configurations | boolean | The operator supports managing more than one backup configuration. This is typically used to store backups on different object stores (for protection purposes) or to send them to different sites. It may also include different lifecycle policies. |
Management Interfaces – mgmi
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
cucol | Resource display columns | boolean | Operator-managed objects (CRDs) include specific fields that provide additional information about the Postgres instances. These fields are shown when querying the Kubernetes resources using tools like kubectl . |
In order to be compliant, operators have to provide at least the following information: * Replication status (primary/replica/etc) * Cluster status (healthy/not healthy) * Postgres major/minor version * Latest base backup date * SSL on/off |
|
kbplg | kubectl plugin | boolean | The users may download an additional kubectl plugin which provides custom commands to manage the operator. | If the feature is provided, include a link to the downloadable plugin in the links field. |
|
bagui | Basic management GUI | boolean | The operator bundles some GUI (web interface or other) that allows to perform basic operations (e.g. cluster creation) graphically. | ✓ | |
fugui | Fully-featured GUI | boolean | The operator bundles a GUI that is fully-featured (that is, in feature-parity with the capabilities provided via the other management interfaces -- typically CRDs). The GUI may provide additional features that cannot be otherwise provided via text interfaces (e.g. graphical representation of resources or operations). |
✓ | |
urgui | GUI users & roles | boolean | The bundled management GUI has authentication and authorization baked in and provides mechanisms to support multiple users and authorize/deny them to perform operations. | Only applies if [mgmi/bagui] or [mgmi/fugui] are provided. Submission should detail in the link and/or comments field how users and roles for the GUI can be managed. |
|
guiss | GUI Single-Sign On | boolean | The bundled management GUI supports integration with Single-Sign On (SSO), like OIDC, identity providers (e.g. Google, Github or Twitter login). | Only applies if [mgmi/bagui] or [mgmi/fugui] are provided. |
|
cogui | GUI database console | boolean | The bundled management GUI includes a console that can connect to any database managed by the operator and send command (e.g. like psql ). |
Only applies if [mgmi/bagui] or [mgmi/fugui] are provided. |
Observability – o11y
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
mtech | Metrics technology | string_array | If the operator supports extracting metrics from Postgres, define how they are handled, which technology receives and processes them. If any of the following technology names apply, use them, and add other names, as needed: * Prometheus * OTEL * OpenTSDB * Nagios * Sensu |
If supported, provide in the comments information about whether the technology is a dependency, is built-in, external, etc. Provide link(s) to the documentation for further information. |
✓ |
expme | Export metrics | boolean | Regardless of how metrics are processed (e.g. as part of the operator), this feature is implemented when the operator allows the user to configure sending metrics to external services, like a metrics SaaS. |
||
cudas | Custom dashboards | boolean | In order to display the captured Postgres metrics, the operator provides specialized Postgres dashboards for the users. | ||
cuale | Custom alerts | boolean | The operator provides bundled specific Postgres alerts to be triggered on the Postgres metrics processed. E.g. there is an alert for transaction wraparound or for unused replication slots. |
||
exdel | Exposed decorated logs | boolean | The operator provides a mechanism to expose all the logs of the managed Postgres instances to a centralized logging tool. The logs must be decorated with extra metadata in order to provide semantic meaning, including the Pod name and namespace, the cluster name, the role of the Postgres instance (e.g. primary, replica, standby-leader, etc.) and the timestamp that will be available to be used to filter logs entries. There is no need to configure the tool in order to obtain required extra metadata from the logs. |
||
explg | Export logs | boolean | The operator allows the user to configure an external sink for the Postgres logs (e.g. a SaaS service). | ||
oo11y | Operator Observability | boolean | The operator is itself a source of telemetry data, potentially including metrics, traces and logs, about its own performance. |
Security – secy
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
opcsc | Operator code security scanning | boolean | The operator code is always scanned for security vulnerabilities. | ✓ | |
imgsc | Image scanning | boolean | Operator-provided images are always scanned for security vulnerabilities. | ✓ | |
sigim | Signed images | boolean | Container images are digitally signed according to the sigstore project. | Compliance may also be achieved by using a technology other than sigstore, as long as it provides an equivalent set of security capabilities. |
|
isbom | Software Bill of Materials | boolean | The operator releases include the SBOM (Software Bill of Materials), a detailed description of all the components, modules, and their dependencies. | SBOM is expected to be in accordance to the Kubernetes SIG BOM. |
|
fgopp | Fine-grained RBAC permissions | boolean | The operator uses a separate serviceaccount that has RBAC permissions that only require the access that is actually needed to create and manage the Kubernetes resources, not more. | ||
noprm | No or justified privileged mode | boolean | The operator-provided containers do not require privileged mode. The container processes do not run as root. |
Reasonable exceptions to this rule can be made for features that require or do not diminish the container's security, e.g. when using eBPF. |
Day 2 Operations – day2
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
amiup | Automated minor upgrades | boolean | The operator can perform a minor version upgrade of a Postgres cluster automatically. This operation can be managed by the user declaratively. |
The operator must provide proper information to the user as to the status and final result of the operation. The operator should provide ongoing status information, and perform the operation with the minimum downtime required. Provide information about the update strategy (i.e. restart of the pods or rolling update followed by a switchover or a restart). |
✓ |
amaup | Automated major upgrades | boolean | The operator can perform a major version upgrade of a Postgres cluster automatically. This operation can be managed by the user declaratively. |
The operator must provide proper information to the user as to the status and final result of the operation. The operator should provide ongoing status information, and perform the operation with the minimum downtime required. |
✓ |
crest | Controlled cluster restart | boolean | Sometimes Postgres needs to be restarted (e.g. changing of a parameter that requires restart). The operator provides means to perform this operation automatically and in a controlled manner (rolling restart) so that the cluster faces a minimal downtime only. |
||
ociup | Container images upgrade | boolean | Similarly to the controlled restart operation, the operator is capable of updating the running container images (which require a pod restart) automatically and with minimal cluster impact. | ||
swtch | Switchover | boolean | If HA capabilities are provided, the operator also provides a mechanism for manual switchover. The user may specify the configuration declaratively and the operator will perform the desired switchover automatically, by demoting the current primary, promoting the a replica, and updating the endpoints/services as required. |
||
sqlmi | SQL Migrations | boolean | The operator provides managed SQL migration capabilities. The user may specify SQL scripts that contain migrations (DDL changes, etc) to be deployed to a given database, having the operator apply them automatically. |
The operator must report back to the user detailed information about the results of the execution(s) of the script(s) provided by the user. |
|
oday2 | Other Day 2 Operations | string_array | The operator provides support for other managed Day 2 operations. | All the mentioned additional day 2 operations need to be possible via declarative configuration and the operator to fully execute them without further user intervention. |
Data Integration – dain
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
kfkin | Kafka integration | boolean | The operator provides a managed solution for automation to export CDC (Change Data Capture) events to Kafka. | Kafka could be an external dependency to the operator. The whole operation is expected to be fully automated, with the user only providing a declarative configuration. |
|
migpg | Migration from Postgres | string_array | The operator provides a managed capability to automatically migrate data from another (external) Postgres database. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. |
Provide one or more of the following values: offline , cdc . |
|
migmy | Migration from MySQL | string_array | The operator provides a managed capability to automatically migrate data from a MySQL database. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. Optionally, the operator may provide additional capabilities to convert the schema from the source database into the target Postgres database. |
Provide one or more of the following values: offline , cdc , schema conversion . |
|
migor | Migration from Oracle | string_array | The operator provides a managed capability to automatically migrate data from an Oracle database. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. Optionally, the operator may provide additional capabilities to convert the schema from the source database into the target Postgres database. |
Provide one or more of the following values: offline , cdc , schema conversion . |
|
migms | Migration from SQL Server | string_array | The operator provides a managed capability to automatically migrate data from a SQL Server database. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. Optionally, the operator may provide additional capabilities to convert the schema from the source database into the target Postgres database. |
Provide one or more of the following values: offline , cdc , schema conversion . |
|
migmo | Migration from MongoDB | string_array | The operator provides a managed capability to automatically migrate data from a MongoDB database. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. Optionally, the operator may provide additional capabilities to convert the schema from the source database into the target Postgres database. |
Provide one or more of the following values: offline , cdc , schema conversion . |
|
migot | Migration from other databases | string_array | The operator provides a managed capability to automatically migrate data from other relational or non-relational databases. Migrations may be offline (source needs to be disconnected from clients while the migration happens) and/or via CDC (Change Data Capture), which allows for near-zero downtime migrations. Optionally, the operator may provide additional capabilities to convert the schema from the source database into the target Postgres database. |
Provide the names of the other database from where migration is supported. |
Sharding – shrd
ID | NAME | TYPE | DESCRIPTION | VENDOR COMPLIANCE | MAIN CATEGORY |
---|---|---|---|---|---|
mshrd | Managed sharding support | boolean | The operator understands horizontal scalability and is capable to automatically deploying sets of clusters (shards) with their accompanying infrastructure (coordinators, services, etc). The user should be able to write a declarative configuration of a sharded cluster and the operator to fully deploy it without any further manual user intervention. |
✓ | |
shrdt | Sharding technology | string_array | If managed sharding support is provided, which technology or technologies are used to provide sharding support (which is not included in Postgres core). | ||
aggds | Aggregated monitoring dashboards | boolean | Since a sharded cluster is a set of (independent) Postgres clusters, an aggregated dashboard is one that provides Observability information across all shards of the cluster. E.g. total database size, tps processed or total number of client connections. |
||
cobkp | Coordinated backups | boolean | A sharded cluster can be backed up by backing up each shard independently, but those backups are not necessarily consistent with each other. If sharding is used, an additional capability is to coordinate backups on a given timestamp so that they are performed or can be restored at the same logical timestamp, so they become consistent with each other. |