Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Jonathan S. Katz
Jonathan S. Katz
Interested in running PostgreSQL natively on Kubernetes ? Let's look at a few quick steps to get up and running with the open source Crunchy PostgreSQL Operator for Kubernetes on your choice of Kubernetes deployment. The Crunchy PostgreSQL Operator (aka " pgo ") provides a quickstart script to automate the deployment of the Crunchy PostgreSQL Operator to a number of popular Kubernetes environments, including Google Kubernetes Engine ( GKE ), OpenShift Container Platform ( OCP ) and...
Read MoreDavid Thomas
David Thomas
For most major upgrades using a utility such as pg_upgrade or a replication tool such as pglogical will be the best solution. However if these options are not available, pg_dumpall can be used to perform a major upgrade. What follows is a guide on how you can safely upgrade your database to a newer version of PostgreSQL with pg_dumpall. You will first need to install the latest PostgreSQL binaries on the new system (hostname new in this example). Once the binaries are installed you will ne...
Read MoreJonathan S. Katz
Jonathan S. Katz
Many applications these days want us to know how close we are to things: • What are the three closest coffee shops to my current location? • Which is the nearest airport to the office? • What are the two closest subway stops to the restaurant? What are the three closest coffee shops to my current location? Which is the nearest airport to the office? What are the two closest subway stops to the restaurant? and countless more examples. Another way of asking these questions is to say “who are my ne...
Read MoreJonathan S. Katz
Jonathan S. Katz
The PostgreSQL 11 release is nearly here (maybe in the next couple of weeks?!), and while a lot of the focus will be on the improvements to the overall performance of the system (and rightly so!), it's important to notice some features that when used appropriately, will provide noticeable performance improvements to your applications. One example of such feature is the introduction of "covering indexes" for B-tree indexes. A covering index allows a user to perform an index-only scan if the...
Read MoreJonathan S. Katz
Jonathan S. Katz
Crunchy Data recently announced the publication of the CIS PostgreSQL Benchmark by the Center for Internet Security , a nonprofit organization that provides publications around standards and best practices for securing technologies systems. This CIS PostgreSQL Benchmark builds on earlier work that Crunchy started when it helped to publish the PostgreSQL Security Technical Implementation Guide ( PostgreSQL STIG ) and provides guidance and steps to help secure your PostgreSQL databases. A CIS...
Read MoreCrunchy Data
Crunchy Data
Running PostgreSQL databases in containerized environments is more popular than ever and is moving beyond running only in local, development environments and into large scale production environments . To answer the need to orchestrate complex, database workloads, the Crunchy Data team created the PostgreSQL Operator to automate many typical database administrator tasks at scale: • Provisioning new PostgreSQL clusters • Scaling up replicas • Setup and manage disaster recovery, high-availabil...
Read MoreJonathan S. Katz
Jonathan S. Katz
Having replicas in a database environment can fulfill many goals: create a high-availability environment, load balance read-only queries across several nodes, have a read-only database to run analytical queries on, and more. PostgreSQL introduced streaming replication in PostgreSQL 9.0 almost 8 years ago to help facilitate satisfying the above requirements, and through the years, the community has added many features to continue to enhance the replication user experience. There are many diff...
Read MoreDouglas Hunley
Douglas Hunley
I recently helped a customer upgrade a PostgreSQL instance from 9.4 on RHEL to 10.x on Ubuntu. While it initially sounded daunting, the use of and some planning actually made it rather straightforward. While there’s nothing new or original in this post, I still felt compelled to write it up for anyone else that might find the info useful as an example in their own endeavors. is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no trigger...
Read MoreJonathan 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
If you have been asked to provide a CSV that someone can open up in their favorite spreadsheet editor, chances are you have used the PostgreSQL COPY command. COPY has been around since the early open source releases of PostgreSQL back in the late 1990s and was designed to quickly get data in and out of PostgreSQL. COPY is also incredibly helpful for ingesting data into a table, especially if you have a lot of it to ingest, and will generally outperform INSERT. Let’s explore a few ways to use C...
Read More