Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more

Posts about Kubernetes

  • 5 min read

    Kubernetes Pod Tolerations and Postgres Deployment Strategies

    Jonathan S. Katz

    The desire to use Pod tolerations to schedule Postgres instances sometimes comes up around complex Kubernetes deployments. To address this feedback, we added support for tolerations to the 4.6 release of the Postgres Operator along with improvements to using node affinity . To use tolerations with PostgreSQL deployments, it helps to understand some of the mechanics behind several Kubernetes features to get the desired result of deploying PostgreSQL to a specific node group. Let's take a loo...

    Read More
  • 6 min read

    Using GitOps to Self-Manage Postgres in Kubernetes

    Jonathan S. Katz

    " GitOps " is a term that I've been seeing come up more and more. The concept was first put forward by the team at Weaveworks as a way to consolidate thought around deploying applications. In essence: your deployment topology lives in your git repository. You can update your deployment information by adding a new commit. Likewise, if you need to revert your system's state, you can rollback to the commit that you want to represent your production environment. Any changes to your deployment topo...

    Read More
  • 4 min read

    Deploy TLS for PgBouncer in Kubernetes

    Jonathan S. Katz

    TLS allows for the secure transmission of data between systems and is also a requirement of many production environments . Part of setting up TLS is ensuring anything communicating over a network within your system also has TLS. If you are not encrypting traffic between all your endpoints, you open yourself up to snooping. An earlier post describes how to set up PostgreSQL clusters with TLS on Kubernetes using the Crunchy Data PostgreSQL Operator . This setup works well for creating encrypte...

    Read More
  • Deploy PostgreSQL With TLS in Kubernetes

    Jonathan S. Katz

    Ensuring data can be securely transmitted is a requirement of many production systems . PostgreSQL supports TLS as a means of encrypting network communication, verifying hosts, and allowing for certificate-based authentication . The TLS functionality of PostgreSQL is extendable into Kubernetes deployments. The Crunchy Data Postgres Operator has provided support for TLS since version 4.3, using Kubernetes Secrets for mounting the TLS components safely to each Pod. The PostgreSQL Operator does...

    Read More
  • 15 min read

    Active-Active PostgreSQL Federation on Kubernetes

    Jonathan S. Katz

    What if I told you that you can create an out-of-the-box active-active, federated PostgreSQL cluster on Kubernetes? Since logical decoding was introduced in PostgreSQL 9.4, I have been fascinated by the various applications it has. In fact, I've used this feature to apply the concepts of change data capture both in theory and practice to the benefit of both applications and users. Logical replication and native partitioning support , introduced in Postgres 10, offered even more possibilit...

    Read More
  • How to Setup PostgreSQL Monitoring in Kubernetes

    Jonathan S. Katz

    You don't need monitoring until you need it. But if you're running anything in production, you always need it. This is particularly true if you are managing databases. You need to be able to answer questions like "am I running out of disk?" or "why does my application have degraded performance?" to be able to troubleshoot or mitigate problems before they occur. When I first made a foray into how to monitor PostgreSQL in Kubernetes , let alone in a containerized environment, I learned that a l...

    Read More
  • 13 min read

    Getting Started with PostgreSQL Operator 4.3 in OpenShift

    James Chanco Jr.

    The first step of working with any software is getting it installed. Based on your environment, this could be as easy as a one-click installer, or require a manual that's hundreds of pages long with thousands of config bits to tune. Deploying complex applications on Kubernetes and OpenShift can often fall somewhere in the middle. For example, deploying an Operator on OpenShift can be viewed as an intimidating thing, but it doesn't have to be. Here we're going to walk through the quickest and e...

    Read More
  • 9 min read

    Multi-Kubernetes Cluster PostgreSQL Deployments

    Jonathan S. Katz

    Advanced PostgreSQL high-availability and disaster recovery strategies designed to maximize uptime involve distributing database clusters across multiple data centers. While on the surface, this may seem intuitive (e.g. eliminate outages due to a single-point-of-failure), there are many nuances to consider, including avoiding the dreaded split-brain problem. To set up a PostgreSQL deployment that spans across data centers (or regions, or Kubernetes clusters), and to mitigate the risk of a...

    Read More
  • 5 min read

    Deploy pgAdmin4 with PostgreSQL on Kubernetes

    Jonathan S. Katz

    Tools like the PostgreSQL Operator make it easy to get PostgreSQL up and running on Kubernetes , but what about actually accessing your Postgres databases? pgAdmin 4 is a popular choice for managing PostgreSQL workloads as it's both accessible from a web browser and provides an intuitive interface for daily PostgreSQL tasks such as running queries, adding new tables, and much more. I've previously shown how to easily deploy pgAdmin 4 with PostgreSQL on Docker , but what about on Kubernete...

    Read More
  • 6 min read

    Set Up and Run PostgreSQL Operator Client (pgo) on Windows

    Steve Pousty

    Today's blog post is for all those people who want to create and manage PostgreSQL or PostGIS clusters AFTER the PostgreSQL Operator has been installed on their Kubernetes/OpenShift cluster. If you need more information on the PostgreSQL Operator we have a great blog post for you and another on latest updates . If you're moving to a Kubernetes infrastructure, having access to the PostgreSQL Operator can make your life a LOT easier. There are plenty of instances in which you don't want t...

    Read More