Percona Operator for PostgreSQL is now Red Hat OpenShift certified. You can now use Percona Operator for PostgreSQL to deploy and manage highly available PostgreSQL clusters on OpenShift. Certification guarantees that our Operator meets standards for interoperability, security, and life cycle management when deployed on Red Hat OpenShift. It is fully supported by Red Hat’s partners, ensuring a stable and reliable deployment in various environments – on-prem and public clouds (like ROSA).
Percona Operator for PostgreSQL is an open-source software that simplifies and automates the full cycle of database operations on Kubernetes. It enables users to create and manage highly available easily, enterprise-grade PostgreSQL clusters. This simplification covers both the initial setup and configuration (Day 1 Operations) and the ongoing management tasks like backups, restores, scaling, and upgrades (Day 2 Operations).
In addition to OpenShift certification, Operator is also available on OperatorHub – a public registry for finding Kubernetes Operators.
Installation
Installing Percona Distribution for PostgreSQL on OpenShift includes two steps:
- Install Percona Operator for PostgreSQL
- Install Percona Distribution for PostgreSQL using the Operator
You can install Percona Operator for PostgreSQL on OpenShift using the Red Hat Marketplace web interface, OperatorHub, or the command line interface.
Install the Operator via the command-line interface
Clone operator repository:
1 2 | git clone -b v2.3.1 https://github.com/percona/percona-postgresql-operator cd percona-postgresql-operator |
Create the OpenShift namespace for your cluster if needed (for example, let’s name it postgres-operator):
1 | oc create namespace postgres-operator |
The Custom Resource Definition for Percona Distribution for PostgreSQL should be created from the deploy/crd.yaml file. Custom Resource Definition extends the standard set of resources that OpenShift “knows” about with the new items (in our case, ones that are the core of the Operator). Apply it as follows:
1 | oc apply --server-side -f deploy/crd.yaml |
Configure the role-based access control (RBAC) for Percona Distribution for PostgreSQL with the deploy/rbac.yaml file.
1 | oc apply -f deploy/rbac.yaml -n postgres-operator |
Start the Operator within OpenShift:
1 | oc apply -f deploy/operator.yaml -n postgres-operator |
After the Operator is started, Percona Distribution for PostgreSQL cluster can be created at any time with the following command:
1 | oc apply -f deploy/cr.yaml -n postgres-operator |
When the creation process is over, oc get pg command will show you the cluster status as ready, and you can try to connect to the cluster.
1 | oc get pg -n postgres-operator |
Install using the Red Hat Marketplace
Deploying through the Red Hat Marketplace implies the usage of application components based on Red Hat’s Universal Base Image (UBI) and includes meeting all of Red Hat’s policy requirements.
Install operator. In the left panel, choose OperatorHub and find Percona Operator for PostgreSQL:
Check that operator was successfully installed in the installed operators folder:
Click to the operator and install postgres with the needed parameters:
Conclusion
With Percona Operator for PostgreSQL now certified on Red Hat OpenShift, organizations can confidently deploy and manage their PostgreSQL clusters, leveraging the full spectrum of Kubernetes operations while ensuring compatibility and support within the OpenShift ecosystem. This certification not only marks a milestone for Percona’s commitment to providing enterprise-grade database solutions but also empowers users with a robust, secure, and efficient way to manage their PostgreSQL databases on one of the most popular Kubernetes platforms. Whether you’re deploying on-premises or in the cloud, the Percona Operator for PostgreSQL simplifies database management, ensuring your data is always available, secure, and performing at its best.
Try Percona Operator for PostgreSQL now
About the Authors
Sergey ProninSergey is a product leader at Percona focusing on delivering robust open-source database and cloud-native solutions. Prior to Percona Sergey led product management and engineering teams in other organizations with a primary focus on products in infrastructure and platforms space.
