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

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.

Getting Started

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 operations or choosing specific objects to monitor.

Getting Started

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...

Introduction

pgBackRest

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 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://github.com/crunchydata/crunchy-containers

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

Charleston, SC and Washington, DC - Crunchy Data Solutions, Inc. (Crunchy), a provider of enterprise PostgreSQL support, technology and training, today announced the release of Crunchy MLS PostgreSQL, an open source database distribution supporting multi-level security.

Crunchy MLS PostgreSQL was developed to support the relational database requirements of the U.S. Government’s Centralized Super Computer Facility. Crunchy is proud to be a part of the Multi-Level Security Ecosystem that includes participants such as Lockheed Martin, Red Hat® and Seagate to provide high performance at massive scale while protecting data internally and externally.

Crunchy CEO Bob Laurence said, “Crunchy MLS PostgreSQL provides an innovative open source alternative to legacy relational database technologies.  With this solution, mission-critical programs can benefit from the combined cost efficiencies of Multi-Level Security and Open Source Software.”

Crunchy and Lockheed Martin collaborated closely to provide PostgreSQL as an open source relational database for multi-level security

Amid the well-deserved hype around the impact of cloud technology and big data analytics, it is possible that casual industry watchers may have missed the real story behind the recent wave of IT re-architecting.

Enabling many of these recent, powerful trends is a newly validated embrace of open source software technology. The movement to OSS solutions is empowering system designers and solution architects to re-examine methodologies that evolved out of the legacy proprietary, closed source software license model. Put simply, OSS allows developers of IT systems to create better results and cut costs.

Enterprise IT leaders in business and government have taken notice of the benefits of OSS. For example, the recently launched U.S. Digital Service published a Digital Services Playbook

January 22, 2015

11:00am - 12:00pm ET

As part of Carahsoft's Open Source Essentials Series, join Jeff McCormick, Crunchy Data Architect and Matt Zager, Red Hat Solution Architect for a complimentary webinar on how OpenShift and PostgreSQL can enable agencies to benefit from an open source infrastructure.

During this session our experts will cover:

• How OpenShift platform-as-a-service technology can help agencies rapidly deploy open source database technology such as PostgreSQL
• How Crunchy's PostgreSQL Management technology enables on-demand database provisioning
• Reference software architecture and sample performance benchmarks