Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Jonathan S. Katz
Jonathan S. Katz
Crunchy Data recently released version 2.6 of the PostgreSQL Kubernetes Operator , a powerful controller that follows the Kubernetes Operator pattern that enables users to provision and manage thousands of PostgreSQL databases at scale. We thought that we would demonstrate some of the features in this latest version over the next few weeks, which includes support for manual database failover, storage selection, node (or server) selection preference, and many goodies that make it easier...
Read MoreJonathan S. Katz
Jonathan S. Katz
One of the many reasons that PostgreSQL is fun to develop with is its robust collection of data types, such as the range type . Range types were introduced in PostgreSQL 9.2 with out-of-the-box support for numeric (integers, numerics) and temporal ranges (dates, timestamps), with infrastructure in place to create ranges of other data types (e.g. inet/cidr type ranges). Range data is found in many applications, from science to finance, and being able to efficiently compare ranges in PostgreS...
Read MoreJeff McCormick
Jeff McCormick
Crunchy Data is pleased to announce an initial implementation of a PostgreSQL Operator for Kubernetes to build on our work with PostgreSQL Containers. This initial implementation provides a user with the ability to perform certain PostgreSQL functions including creating PostgreSQL clusters, performing database backup and restores and viewing persistent volume claims. Last November the team at CoreOS introduced the concept of an “application-specific controller” for Kubernetes called software Op...
Read MoreJeff McCormick
Jeff McCormick
This blog provides guidance on how to build a PostgreSQL cluster using the new Kubernetes feature - StatefulSet . Using this StatefulSet capability provides a very simple, Kubernetes native, mechanism to make clustering decisions when deploying a PostgreSQL cluster. The Crunchy PostgreSQL Container Suite is a set of containers that can be used to deploy, monitor, and administer the open source PostgreSQL database. More details can be found in the crunchy-containers GitHUB repository here In...
Read MoreJeff McCormick
Jeff McCormick
As we have discussed previously , Crunchy Data supplies a set of open source PostgreSQL and PostgreSQL related containers. The Crunchy PostgreSQL Container Suite includes containers that deploy, monitor, and administer the open source PostgreSQL database, for more details view this GitHub repository . In this post we’ll show you how to deploy a PostgreSQL cluster using Helm , a Kubernetes package manager. (This blog cross-posted at https://blog.kubernetes.io/2016/09/creating-postgresql-clu...
Read MoreJeff McCormick
Jeff McCormick
In this blog post, we will discuss how PostgreSQL metrics are collected and stored as part of the Crunchy Container Suite project running within the Red Hat OpenShift Container Platform. Crunchy Data is a Red Hat Technology Connect and OpenShift Primed partner. The Crunchy Container Suite is an open source collection of docker container images designed to run and manage PostgreSQL in a cloud-native environment. The Crunchy Container Suite can be found within this Github repository: https://gith...
Read MoreJeff McCormick
Jeff McCormick
Crunchy Data is a leading provider of trusted open source PostgreSQL and PostgreSQL support, technology and training. In an earlier blog , the basics of the Crunchy PostgreSQL containers were presented demonstrating how easy and efficient it is to run PostgreSQL in containers such as Docker. In this follow up several new advanced features are highlighted from the Crunchy PostgreSQL for Kubernetes . The containers are open source and can be run either stand-alone, within Kubernetes, or within R...
Read More