Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Andrew L'Ecuyer
Andrew L'Ecuyer
One of the great new features recently added to Kubernetes - native Sidecar Containers - continues to get closer to GA with each new Kubernetes release. I was reviewing all of the great progress recently made by the Kubernetes Enhancement Proposal (KEP) on Sidecar Containers and realized this feature has already produced some exciting results. For instance, this feature is already making it easier than ever before to use Crunchy Postgres for Kubernetes with two important service mesh solut...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
As a team you often get handed a piece of software to deploy and manage, for example Red Hat's Ansible Automation Platform (AAP) or Quay. Red Hat's guide is to run and manage this in OpenShift and great, you're already comfortable with OpenShift and have a decent size deployment. Turns out pretty early on you've got a decision to make you didn't even realize was a decision, what are you going to do about the database? Most software needs a database – and the database of choice is overwhelmingly...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
We're excited to announce the release of Crunchy Postgres for Kubernetes 5.5. Included in this release are great updates to database administration, monitoring, connection pooling and more. Specific highlights include: • An updated pgAdmin experience, including the ability to deploy one pgAdmin for use with multiple Postgres clusters • Easier installation of the metrics and monitoring tools, along with the added ability to monitor standby clusters • Updates to PgBouncer including support for pre...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Lukas Fittl recently posted one of his 5 minutes of Postgres videos about his experimentation with different Kubernetes Postgres Operators: Postgres on Kubernetes, choosing the right operator, and handling major version upgrades . One passage about version updates caught my interest: The other article I found interesting was this post by Andrew from the Crunchy Data team , where he describes how the PGO operator now makes it easy to do major version upgrades. This is actually pretty cool. I th...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Modern day production ready Postgres solutions require quite a bit of sophistication and automation. Changes need to be applied in a uniform and safe way. DevOps and SRE teams need to be in control system updates while limiting disruption to their users. With the release of PGO v5.1 , we are excited to announce enhancements in each of these areas. Not only does PGO v5.1 now automatically rollout all PostgreSQL configuration changes, but it allows you to protect your running databases against ou...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Recently, there has been a bit of a debate here at Crunchy Data around SQL editors. While some members of the Crunchy Team such as Elizabeth ( @e_g_christensen ) prefer pgAdmin 4, others such as Craig (@ craigkerstiens ) prefer using psql . And one the great things about the PostgreSQL ecosystem is that there is no right answer to this debate! Instead, you have choice and flexibility when it comes to finding and using the tools that meet your specific database development and/or management need...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Whether upgrading PGO itself, or upgrading the PostgreSQL databases PGO manages, seamless upgrades should be a core feature for any cloud or Kubernetes-based database solution. As a result, one of the goals when we set out to build version five of PGO, the Postgres Operator from Crunchy Data, was to provide a seamless and user-friendly upgrade experience. Today we’re excited to introduce support for major version PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessl...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
A colleague of mine recently tweeted the following, highlighting the challenges often associated with database upgrades: Last week had 3 calls before noon of people having difficulty with database upgrades and connection scaling. Two things that should be staples for a database provider and they had no idea until 6 months in when they tried to upgrade. As an industry we can build better. — Craig Kerstiens (@craigkerstiens) March 28, 2022 When I saw that tweet, I couldn’t help but appreciate the...
Read MoreAndrew L'Ecuyer
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 MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Crunchy Data recently released its latest version of the open source PostgreSQL Operator for Kubernetes , version 4.2. Among the various enhancements included within this release is support for Synchronous Replication within deployed PostgreSQL clusters. As discussed in our prior post , the PostgreSQL Operator 4.2 release introduces distributed consensus based high-availability . For workloads that are sensitive to transaction loss, the Crunchy PostgreSQL Operator supports PostgreSQL synchro...
Read More