Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Joe Conway
Joe Conway
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. While the STIG was authored for the benefit of the U.S. Government, the DISA PostgreSQL STIG offers security-conscious enterprises a comprehensive guide for the configuration and operation of open source PostgreSQL. Enterprises can ref...
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
PLEASE READ THE UPDATED VERSION: AN EASY RECIPE FOR CREATING A POSTGRESQL CLUSTER WITH DOCKER SWARM The below content has been deprecated in favor of An Easy Recipe for Creating a PostgreSQL Cluster with Docker Swarm . 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. To sta...
Read MoreStephen Frost
Stephen Frost
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 thi...
Read MoreStephen Frost
Stephen Frost
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’ve made 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 devel...
Read MoreStephen Frost
Stephen Frost
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....
Read MoreJason O'Donnell
Jason O'Donnell
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. This guide assumes pgAudit has already been installed on the target DB server. For more instructions on installing pgAudit, see the official documentation here . pgAudit au...
Read MoreJason O'Donnell
Jason O'Donnell
The PostgreSQL Audit extension (pgaudit) provides detailed session and/or object audit logging via the standard PostgreSQL logging facility. Basic statement logging can be provided by the standard logging facility in PostgreSQL. Out of the box logging provided by PostgreSQL is acceptable for monitoring and other usages but does not provide the level of detail generally required for an audit. pgAudit enhances PostgreSQL's logging abilities by allowing administrators to audit specific classes of o...
Read MoreDavid Steele
David Steele
In our ongoing series of blog posts designed to help you better run, manage, and support PostgreSQL, today we have a post discussing pgBackRest, a powerful open source tool for managing backups and restores of PostgreSQL databases... pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses...
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 More