Crunchy Blog

PostgreSQL, Analytics, PL/R, postgis

Preprocessing Data for Spatial Analysis with PostGIS and PL/R

April 18, 2017

This is the second in a series of posts intended to introduce PostgreSQL users to PL/R, a loadable procedural language that enables a user to write user-defined SQL functions in the R programming language.  This post builds on the example introduced in the initial post by demonstrating the steps associated with preprocessing the Normalized Difference Vegetation Index (NDVI) satellite raster data in preparation for spatial analytics. 

PostgreSQL, Analytics, PL/R

Spatial Analytics with PostGIS, PL/R and R

April 11, 2017

This is the first in a series of posts intended to introduce PostgreSQL users to PL/R, a loadable procedural language that enables a user to write user-defined SQL functions in the R programming language.  When further combined with PostGIS, the geospatial extender for PostgreSQL, users can perform powerful spatial analytics within the PostgreSQL database.  This initial post introduces PL/R and R, provides set up instructions for following the Spatial Analytics example to be used in this series of posts, and provides introductory instruction on Geocoding with PostGIS, R and PL/R.

PostgreSQL, Kubernetes, Docker, containers

PostgreSQL Operator for Kubernetes

March 28, 2017

Crunchy Data is pleased to announce an initial implemention 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.


Announcing the PostgreSQL STIG

March 27, 2017

Crunchy Data recently announced the publication of the PostgreSQL Security Technical Implementation Guide (STIG) by the United States Defense Information Systems Agency (DISA), making PostgreSQL the first open source database to provide a published STIG.


Deploying PostgreSQL Clusters using Kubernetes StatefulSets

February 26, 2017

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.

Docker, containers

Easy PostgreSQL Cluster Recipe Using Docker 1.12 and Swarm

December 22, 2016

In this blog I’ll show you how to deploy a PostgreSQL cluster using the latest Docker 1.12 technology. Updates to Docker in their 1.12 release greatly simplify deploying a PostgreSQL cluster. IP addresses and hostnames used in this blog are just examples and not mandated.

PostgreSQL, PGConf

A Committer's Preview of PGConf.EU 2016 - Part 3

October 27, 2016

Today, I am wrapping up my preview of next week's PGConf.EU conference. I'm really excited about all of the excellent topics and speakers that we get to choose from! Once again, here's the full Schedule.


On Friday morning, I have to recommend Arthur Zakirov and Oleg Bartunov’s talk on Better Full Text Search in PostgreSQL, even if you don’t use any Full Text Search today, they will be discussing the new RUM indexing capability which is currently being worked on.  If that isn’t your thing, then definitely check out Jan Wieck’s talk on Peeking into the black hole called PL/pgSQL - The new PL profiler.

PostgreSQL, PGConf

A Committer's Preview of PGConf.EU 2016 - Part 2

October 26, 2016

Today, I will continue with my preview of the exciting talks at the upcoming PGConf.EU conference. In Part 1, I discussed the talks that will happen on Wednesday. Today, I want to dive into the Thursday sessions.


Starting in early on Thursday morning,if you haven’t tracked all the fantastic progress we’vemade with PostgreSQL 9.6 then definitely go to Magnus Hagander’s talk on What's New in PostgreSQL 9.6.  If all of that is old news to you and you’re looking at PG10 with the other developers, then the talk to be at is Anastasia Lubennikova and Konstantin’s on Page Level Compression and Encryption in Postgres, which is an absolutely amazing and fantastic direction for PostgreSQL to be going in and I’m quite excited about it.


PostgreSQL, PGConf

A Committer's Preview of PGConf.EU 2016 - Part 1

October 25, 2016

Only one week left til PGConf.EU in Tallinn, Estonia!

Next week will be PGConf.EU’s 8th conference, having traveled to many different parts of Europe, and lately moving on a North-East trajectory, two years ago in Madrid, last year in Vienna, is now in Tallinn, Estonia with another fantastic line-up of talks.  


Here are the talks which I am most interested in this year.  Warning for the unwary, I’m a PostgreSQL Committer, so I tend to be quite developer heavy when it comes to my talk selections.

Crunchy Latest, Managing PostgreSQL

pgAudit: Auditing Database Operations Part 2

October 14, 2016


In the last blog post, pgAudit was configured to audit entire classes of statements (session auditing). Session auditing works great, but it can generate a lot of logs and not every administrator needs all that information. In this blog post pgAudit will be configured to use an auditing role to watch only specific objects.