# Crunchy Data PostgreSQL Operator

!!! info "Architectural Context"
    Detailed reference for Crunchy Data PostgreSQL Operator in the context of Data & Advanced Analytics.

## Standard Reference

  - [crunchydata blog: Deploying Active-Active PostgreSQL on Kubernetes](https://www.crunchydata.com/blog/active-active-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [crunchydata blog: What's New in Crunchy PostgreSQL Operator 4.0](https://www.crunchydata.com/blog/crunchy-postgres-kubernetes-operator-4.0)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Monitoring PostgreSQL clusters in kubernetes](https://www.crunchydata.com/blog/monitoring-postgresql-clusters-in-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Deploy High-Availability PostgreSQL Clusters on Kubernetes by Example](https://www.crunchydata.com/blog/deploy-high-availability-postgresql-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Migrating from Oracle to PostgreSQL: Tips and Tricks](https://www.crunchydata.com/blog/migrating-from-oracle-to-postgresql-questions-and-considerations)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Scheduled PostgreSQL Backups and Retention Policies with Kubernetes](https://www.crunchydata.com/blog/schedule-postgresql-backups-and-retention-with-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Guard Against Transaction Loss with PostgreSQL Synchronous Replication](https://www.crunchydata.com/blog/synchronous-replication-in-the-postgresql-operator-for-kubernetes-guarding-against-transactions-loss)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Crunchy PostgreSQL for Kubernetes 4.3 Released](https://www.crunchydata.com/news/crunchy-postgresql-for-kuberenetes-4.3)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Deploy pgAdmin4 with PostgreSQL on Kubernetes](https://www.crunchydata.com/blog/deploy-pgadmin4-with-postgresql-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Multi-Kubernetes Cluster PostgreSQL Deployments](https://www.crunchydata.com/blog/multi-kubernetes-cluster-postgresql-deployments)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Quickly Document Your Postgres Database Using psql Meta-Commands](https://www.crunchydata.com/blog/d-meta)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Fast CSV and JSON Ingestion in PostgreSQL with COPY](https://www.crunchydata.com/blog/fast-csv-and-json-ingestion-in-postgresql-with-copy)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Composite Primary Keys, PostgreSQL and Django](https://www.crunchydata.com/blog/composite-primary-keys-postgresql-and-django)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Getting Started with PostgreSQL Operator 4.3 in OpenShift](https://www.crunchydata.com/blog/getting-started-with-postgresql-operator-4.3-in-openshift)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Introducing the Postgres Prometheus Adapter](https://www.crunchydata.com/blog/using-postgres-to-back-prometheus-for-your-postgresql-monitoring-1)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Setup ora2pg for Oracle to Postgres Migration](https://www.crunchydata.com/blog/setup-ora2pg-for-oracle-to-postgres-migration)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: pgBackRest - Performing Backups on a Standby Cluster](https://www.crunchydata.com/blog/pgbackrest-performing-backups-on-a-standby-cluster)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: How to Setup PostgreSQL Monitoring in Kubernetes](https://www.crunchydata.com/blog/setup-postgresql-monitoring-in-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: PostgreSQL Monitoring for Application Developers: The DBA Fundamentals](https://www.crunchydata.com/blog/postgresql-monitoring-for-application-developers-dba-stats)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Tuning Your Postgres Database for High Write Loads](https://www.crunchydata.com/blog/tuning-your-postgres-database-for-high-write-loads)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Using the PostgreSQL Operator with Rook Ceph Storage](https://www.crunchydata.com/blog/crunchy-postgresql-operator-with-rook-ceph-storage)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: An Easy Recipe for Creating a PostgreSQL Cluster with Docker Swarm](https://www.crunchydata.com/blog/an-easy-recipe-for-creating-a-postgresql-cluster-with-docker-swarm)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Deploying the PostgreSQL Operator on GKE](https://www.crunchydata.com/blog/install-postgres-operator-kubernetes-on-gke-ansible)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Using GitOps to Self-Manage Postgres in Kubernetes 🌟](https://www.crunchydata.com/blog/gitops-postgres-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [info.crunchydata.com: Kubernetes Pod Tolerations and Postgres Deployment Strategies](https://www.crunchydata.com/blog/kubernetes-pod-tolerations-and-postgresql-deployment-strategies)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Helm, GitOps and the Postgres Operator](https://www.crunchydata.com/blog/gitops-postgres-kubernetes-helm)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Crunchy Postgres Operator 4.6.0 🌟](https://www.crunchydata.com/blog/crunchy-postgres-operator-4.6.0)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Deploy PostgreSQL With TLS in Kubernetes](https://www.crunchydata.com/blog/set-up-tls-for-postgresql-in-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Announcing Google Cloud Storage (GCS) Support for pgBackRest](https://www.crunchydata.com/blog/announcing-google-cloud-storage-gcs-support-for-pgbackrest)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Query Optimization in Postgres with pg_stat_statements](https://www.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Active-Active PostgreSQL Federation on Kubernetes](https://www.crunchydata.com/blog/active-active-postgres-federation-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Next Generation Crunchy Postgres for Kubernetes 5.0 Released](https://www.crunchydata.com/news/next-generation-crunchy-postgres-for-kubernetes-released)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: pgBackRest Point-In-Time Recovery Using Crunchy PostgreSQL Operator](https://www.crunchydata.com/blog/pgbackrest-point-in-time-recovery-using-crunchy-postgresql-operator)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Using Cert Manager to Deploy TLS for Postgres on Kubernetes](https://www.crunchydata.com/blog/using-cert-manager-to-deploy-tls-for-postgres-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Can't Resize your Postgres Kubernetes Volume? No Problem!](https://www.crunchydata.com/blog/resize-postgres-kubernetes-volume-instance-sets)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Your Guide to Connection Management in Postgres 🌟](https://www.crunchydata.com/blog/your-guide-to-connection-management-in-postgres)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: PostgreSQL 14 on Kubernetes (with examples!)](https://www.crunchydata.com/blog/postgresql-14-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Kubernetes + Postgres Cluster From Scratch on Rocky 8](https://www.crunchydata.com/blog/kube-cluster-from-scratch-on-rocky-8)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [blog.crunchydata.com: Announcing Postgres Container Apps: Easy Deploy Postgres Apps](https://www.crunchydata.com/blog/announcing-postgres-container-apps-easy-deploy-postgres-apps)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Announcing the Crunchy Data Developer Portal](https://www.crunchydata.com/blog/announcing-the-crunchy-data-developer-portal)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Crunchy PostgreSQL and Openshift](https://www.redhat.com/en/blog/leveraging-the-crunchy-postgresql)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [ref1](https://www.redhat.com/en/blog/understanding-service-accounts-sccs)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span> — - [ref2](https://docs.openshift.com/container-platform/4.1/authentication/understanding-and-creating-service-accounts.html)
    - [ref3](https://docs.openshift.com/container-platform/4.1/authentication/managing-security-context-constraints.html#role-based-access-to-ssc_configuring-internal-oauth)
  - [crunchydata.com](https://www.crunchydata.com)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [github.com/CrunchyData](https://github.com/CrunchyData)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [github.com/CrunchyData/postgres-operator](https://github.com/CrunchyData/postgres-operator) <span class='md-tag md-tag--info'>⭐ 4406</span>  <span class='md-tag md-tag--info'>[ENTERPRISE-STABLE]</span>
  - [Documentation: Crunchy Data Container Suite 🌟](https://access.crunchydata.com/documentation/crunchy-postgres-containers/latest)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [slideshare.net: Deploying PostgreSQL on Kubernetes](https://www.slideshare.net/vyruss000/deploying-postgresql-on-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [slideshare.net: Operating PostgreSQL at Scale with Kubernetes](https://www.slideshare.net/jkatz05/operating-postgresql-at-scale-with-kubernetes-137132067)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Youtube: Demo of Crunchy Data Postgres Operator v1.0.0 (2017)](https://www.youtube.com/watch?v=HX10WWTRiTY)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Youtube: Crunchy PostgreSQL Operator for Kubernetes 3.4 Overview (2018)](https://www.youtube.com/watch?v=gaXlrlz7GVc)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Youtube: OpenShift Meetup Tokyo #05 - Operator and Operator Lifecycle Manager' on OpenShift (2019, openshift 4.1)](https://www.youtube.com/watch?v=X4vuktlK0Tg)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [opensource.com: Scaling PostgreSQL with Kubernetes Operators 🌟](https://opensource.com/article/19/2/scaling-postgresql-kubernetes-operators)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [thenewstack.io: Advanced Kubernetes Namespace Management with the PostgreSQL' Operator 🌟](https://thenewstack.io/advanced-kubernetes-namespace-management-with-the-postgresql-operator)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [postgresql.org: Crunchy PostgreSQL Operator 4.5: Enhanced Monitoring, Custom' Annotations, PostgreSQL 13 🌟](https://www.postgresql.org/about/news/crunchy-postgresql-operator-45-enhanced-monitoring-custom-annotations-postgresql-13-2086)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [youtube: OCB: High Availability PostgreSQL and more on OpenShift - Jonathan' Katz (Crunchy Data) 🌟](https://www.youtube.com/watch?v=9jbR9lZuSU0)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [youtube: Install and use Crunchy PostgreSQLfor OpenShift operator for simple' todo app on OpenShift 🌟](https://www.youtube.com/watch?v=9wuUXi6Qbis&ab_channel=MichaelBornholdtNielsen)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [dzone: PostgreSQL HA and Kubernetes](https://dzone.com/articles/postgresql-ha-and-kubernetes)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Crunchy Data Developer Portal](https://www.crunchydata.com/developers)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [The PostgreSQL Operator Installer with kubectl](https://access.crunchydata.com/documentation/postgres-operator/4.3.0/installation/postgres-operator)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [ref1](https://docs.openshift.com/container-platform/4.1/authentication/using-service-accounts-in-applications.html)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [ref1](https://docs.openshift.com/container-platform/3.6/admin_guide/manage_scc.html)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [ref1](https://access.crunchydata.com/documentation/postgres-operator/latest/operatorcli/pgo-overview)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [crunchy-pgadmin4](https://access.crunchydata.com/documentation/crunchy-postgres-containers/4.3.0/container-specifications/crunchy-pgadmin4)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [pgAdmin 4](https://access.crunchydata.com/documentation/crunchy-postgres-containers/4.3.0/examples/administration/pgadmin4)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [Kubernetes.io: Operator pattern](https://kubernetes.io/docs/concepts/extend-kubernetes/operator)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>
  - [ref3](https://dzone.com/articles/understanding-openshift-security-context-constrain)  <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span>

## Data Architecture

### Databases

#### PostgreSQL

  - **(2025)** [learn.crunchydata.com](https://www.crunchydata.com/developers/tutorials) 🌟🌟🌟 <span class='md-tag md-tag--info'>[COMMUNITY-TOOL]</span> <span class='md-tag md-tag--secondary'>[GUIDE]</span> — An interactive database training portal detailing progressive PostgreSQL configuration, clustering, and troubleshooting. Crucial for architects planning highly available, stateful cloud-native storage engines.

---
💡 **Explore Related:** [Databases](./databases.md) | [Message Queue](./message-queue.md) | [NoSQL](./nosql.md)