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

Posts about Kubernetes

  • 5 min read

    Cloud Data Sources for the Postgres Operator for Kubernetes

    Andrew L'Ecuyer

    One of the many powerful features in PGO , the open source Postgres Operator from Crunchy Data , is the ability to use an existing data source to initialize a new Postgres cluster. If you are cloning an existing cluster or migrating volumes, PGO data sources make cluster initialization easy. New in PGO v5.0.5, we've expanded support for data sources even further with the introduction of cloud data sources! We’re excited to offer this new feature to customers onboarding to Crunchy Postgres for...

    Read More
  • 8 min read

    Kubernetes + Postgres Cluster From Scratch on Rocky 8

    Joe Conway

    Co-authored by Brian Pace I was excited to hear that Kubernetes 1.22 was recently released with better support for cgroup-v2 and has support for Linux swap . These changes potentially resolve two of my chief complaints about running Postgres under Kubernetes. Obviously it will take some time before we see uptake in the wild on these features, but I wanted to become familiar with them. For what it's worth, I also want to eventually play with the new alpha seccomp support in Kubernetes v1....

    Read More
  • 7 min read

    Streaming Replication Across Kubernetes Postgres Clusters

    Brian Pace

    UPDATE TO THIS CONTENT: Since releasing this article, newer versions of Crunchy Postgres for Kubernetes have additional features for streaming replication across clusters. See our post that accompanied the release: Multi-Cloud Strategies with Crunchy Postgres for Kubernetes . Read the disclaimer above, as this content is now out of date. A common need when running PostgreSQL in Kubernetes is to establish a standby database in a different Kubernetes cluster. In a typical configuration there...

    Read More
  • 9 min read

    Keep Storage and Backups when Dropping Cluster with PGO

    Brian Pace

    As a Solutions Architect at Crunchy Data, I work directly with customers testing and deploying Crunchy Postgres for Kubernetes . I often see our customers fully removing a PGO cluster during testing or migrations and still needing to keep their storage and backups intact. In this post, I will dig into the steps to removing your PGO cluster while keeping your storage and backups. With the move to a declarative approach in 5.0 PGO, storage and backup retention can be accomplished by following a...

    Read More
  • 3 min read

    Using TimescaleDB with PGO, the open source Postgres Operator

    Jonathan S. Katz

    One of the many reasons " the answer is Postgres " is due to its extensibility. The ability to extend Postgres has given rise to an ecosystem of Postgres extensions that change the behavior of the database to support a wide range of interesting capabilities. At Crunchy Data we are big fans of PostGIS , the geospatial extender for Postgres. Another extension we are asked about often is TimescaleDB . TimescaleDB is an open-source extension designed to make SQL scalable for time-series data....

    Read More
  • 7 min read

    Multifactor SSO Authentication for Postgres on Kubernetes

    Jonathan S. Katz

    Did you know that PostgreSQL 12 introduced a way for you to provide multifactor (aka "two-factor") authentication to your database? This comes from the ability to set as part of your pg_hba.conf file, which manages how clients can authenticate to PostgreSQL. When you specify , PostgreSQL requires a connecting client to provide a certificate that is valid against its certificate authority ( CA ) and the certificate's common name ( CN ) matches the username the client is authenticating...

    Read More
  • 6 min read

    Can't Resize your Postgres Kubernetes Volume? No Problem!

    Jonathan S. Katz

    You've built an application and are using Postgres to run it. You move it into production. Things are going great. So great that you've accumulated so much data that you need to resize your disk. Before the cloud, this often involved either expanding your disk partitioning or getting a new disk, both of which are costly operations. Cloud has made this much easier: disk resizes can occur online or transparently to the application, and can be done as simply as clicking a button (such as in Crunch...

    Read More
  • Database Security Best Practices on Kubernetes

    Jonathan S. Katz

    As more data workloads shift to running on Kubernetes , one of the important topics to consider is security of your data. Kubernetes brings many conveniences for securing workloads with the ability to extend security functionality databases through the use of the Operator pattern . Database security best practices on Kubernetes is a frequent conversation we're having with our customers around deploying PostgreSQL on Kubernetes with PGO , the open source Postgres Operator from Crunchy Dat...

    Read More
  • 4 min read

    Encrypting Postgres Data at Rest in Kubernetes

    Jonathan S. Katz

    Encrypting data at rest is often an important compliance task when working on securing your database system . While there are a lot of elements that go into securing a PostgreSQL database , encrypting data at rest helps to protect your data from various offline attacks including the stealing of a disk or tampering. Disk encryption is a popular feature among public database-as-a-service providers, including Crunchy Bridge, to protect data in a multi-tenant environment. There is ongoing work i...

    Read More
  • 11 min read

    Multi-Cluster Postgres Federation on Kubernetes with Postgres 14 Using GitOp

    Jonathan S. Katz

    One of the reasons why I like deploying Postgres on Kubernetes with PGO , the open source Postgres Operator , is that it makes it easier to set up distributed database systems. One example is using Postgres for edge computing , and you can build an edge computing architecture with both Postgres and Debezium on Kubernetes. You can also do some fun things with logical replication and many read/write nodes. I posted an example of doing this last year about how you could set up an active...

    Read More