Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Jonathan S. Katz
Jonathan S. Katz
It is important (understatement) that you take regularly scheduled backups of your PostgreSQL system as well as manage how many backups you have, which is known as "backup retention." These best practices ensure that you always have a recent backup of your database system to recover from in the event of a disaster (or use to clone a new copy of your database ) and that you don't run out of storage on your backup device or blow up your object storage bill (true story from a previous life, I ha...
Read MoreCrunchy Data
Crunchy Data
One of the great things about PostgreSQL is its reliability: it is very stable and typically “just works.” However, there are certain things that can happen in the environment that PostgreSQL is deployed in that can affect its uptime, such as: • The database storage disk fails or some other hardware failure occurs • The network on which the database resides becomes unreachable • The host operating system becomes unstable and crashes • A key database file becomes corrupted • A data center is lost...
Read MoreJonathan S. Katz
Jonathan S. Katz
UPDATE : Read the updated " How to Setup PostgreSQL Monitoring in Kubernetes " which is even easier to set up and provides additional monitoring features! The open source PostgreSQL Operator provides many features that are required to run a production database-as-a-service on Kubernetes , including provisioning PostgreSQL clusters, performing backup and restore operations , and manage high-availability runtime environments. This time, we are going to look at a very important part of managing...
Read MoreJonathan S. Katz
Jonathan S. Katz
The PostgreSQL Operator provides users with a few different methods to perform PostgreSQL cluster operations, via: • a REST API • , PostgreSQL Operator Command Line Interface ( CLI ) • Directly interfacing with Kubernetes, including various APIs and custom resource definitions ( CRDs ). a REST API , PostgreSQL Operator Command Line Interface ( CLI ) Directly interfacing with Kubernetes, including various APIs and custom resource definitions ( CRDs ). While the REST API and pgo provide...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
The Crunchy PostgreSQL Operator supports various forms of storage for provisioning PostgreSQL clusters in a Kubernetes environment. One such provider is Rook , which provides an abstract layer around multiple storage systems available in Kubernetes, which makes it even more convenient to choose between multiple storage engines. One storage engine that Rook supports is Ceph , which provides several types of distributed storage platforms including block-level storage, which is very helpful f...
Read MorePatrick McLaughlin
Patrick McLaughlin
The Crunchy PostgreSQL Operator 4.0 provides an open source PostgreSQL-as-a-Service for Kubernetes platform. This post provides some easy steps to help you get started, specifically deploying the Crunchy PostgreSQL Operator in Google Kubernetes Engine ( GKE ) making use of the Crunchy PostgreSQL Operator Ansible Installer . The Crunchy PostgreSQL Operator 4.0 provides Ansible playbooks to automate the installation. These Ansible playbooks allow users to deploy the operator to a variety o...
Read MoreJeff McCormick
Jeff McCormick
Crunchy Data is pleased to release PostgreSQL Operator 4.0 . Crunchy PostgreSQL Operator extends Kubernetes to give you the power to easily create, configure and manage PostgreSQL clusters at scale. When combined with the Crunchy PostgreSQL Container Suite , the Crunchy PostgreSQL Operator provides an open source software solution for PostgreSQL scaling, high-availability, disaster recovery, monitoring, and more. All of this capability comes with the repeatability and automation that comes fr...
Read MoreDave Cramer
Dave Cramer
Kubernetes is a very popular container orchestration framework. I’ll show you how to get Symmetric-DS working on a single Kubernetes instance. I had previously explored how to build an active-active PostgreSQL cluster using Symmetric-DS. The steps are essentially the same on Kubernetes: 1. Start 2 PostgreSQL pods 2. Create a user and a database on each pod/instance 3. Start the primary symmetric-ds pod 4. Add the symmetric-ds triggers and routes 5. Open registration 6. Start the secondary s...
Read MoreChirag Dave
Chirag Dave
The Crunchy PostgreSQL Operator is a controller that runs within a Kubernetes cluster that provides a means to deploy and manage PostgreSQL clusters. pgBackRest is one of the most simple yet powerful backup and restore tools, with a bunch of rich features especially for backing up large databases. At Crunchy Data we have made significant improvements in the PostgreSQL Operator functionality especially for integrating pgBackRest support . This blog post will demonstrate how pgBackRest is we...
Read MoreJeff McCormick
Jeff McCormick
Crunchy Data is happy to announce the release of the open source PostgreSQL Operator 3.5 for Kubernetes project, which you can find here: https://github.com/CrunchyData/postgres-operator/ This latest release provides further feature enhancements designed to support users intending to deploy large-scale PostgreSQL clusters on Kubernetes , with enterprise high-availability and disaster recovery requirements. When combined with the Crunchy PostgreSQL Container Suite , the PostgreSQL Operato...
Read More