---
title: "This Week's PostgreSQL News (#72)"
publication: "Postgres Weekly"
issue: 72
published_at: "2014-09-10"
canonical_url: "https://postgresweekly.com/issues/72"
---

Postgres Weekly Issue 72 - September 10, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/72)**Postgres Weekly****Issue 72**
September 10, 2014[OPM: An Open PostgreSQL Monitoring Software Suite](http://opm.io/?utm_source=postgresweekly&utm_medium=email)OPM is an open source solution to help you collect stats and display them to monitor your Postgres databases. Give it a look or try [the demo](http://opm.io/#demo)._OPM Development Group_[Caching with Postgres Materialized Views](http://www.matchingnotes.com/caching-with-postgres-materialized-views.html?utm_source=postgresweekly&utm_medium=email)Materialized views were long awaited within Postgres. Now that they’re here see what they can do for you and how you can quickly and easily improve the performance of your apps with them._James Croft_[Postgres Logs in JSON Format](http://michael.otacoo.com/postgresql-2/postgres-logs-json/?utm_source=postgresweekly&utm_medium=email)Want your Postgres logs in JSON format so you can pipe them right back into Postgres? Here’s your answer for doing just that, or possibly taking the JSON and doing something else…_Michael Paquier_[Tales from the Trenches – Postgres Support Calls](http://blogs.enterprisedb.com/2014/07/22/tales-from-the-trenches-postgres-support-calls/?utm_source=CP=NL=2SupportTrenches?utm_source=postgresweekly&utm_medium=email)The vast majority of questions and complications arise during the deployment and maintenance phases of Postgres projects, not during development or POC. And with good reason —Postgres is an easy database to get ready for production, and to write code for. But planning ahead is key to your project’s success. Read more about the Tales from The Trenches and get prepared with a brief [Architectural Health Check.](http://www.enterprisedb.com/AHC?utm_source=CP&utm_medium=NL&utm_campaign=2SupportTrenches)_EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://blogs.enterprisedb.com/2014/07/22/tales-from-the-trenches-postgres-support-calls/?utm_source=CP=NL=2SupportTrenches?utm_source=postgresweekly&utm_medium=email)[Turn Your Postgres Queries into Charts](http://tapoueh.org/blog/2014/08/25-pgcharts.html?utm_source=postgresweekly&utm_medium=email)pgcharts is a project that can create charts out of the results from queries._Dimitri Fontaine_[Automatic Off-site Backups for your Heroku Postgres Databases](http://stefan.haflidason.com/automatic-off-site-backups-for-your-heroku-postgres-databases/?utm_source=postgresweekly&utm_medium=email)Running on Heroku Postgres and want to backup your database somewhere else besides their automated backups? Here’s a great guide for backing up your DB directly to S3._Stefan Haflidason_[Announcing BDR RPMs for 9.4](http://blog.2ndquadrant.com/announcing-bdr-rpms-9-4/?utm_source=postgresweekly&utm_medium=email)If you’re anxious for bi-directional replication, it’s here and something you can play with. Proceed with caution as one 9.4 isn’t fully released yet and also not fully baked. Any testing and feedback will help improve the quality._Craig Ringer_[PLV8 and Harmony Scoping](http://adpgtech.blogspot.com/2014/09/plv8-and-harmony-scoping.html?utm_source=postgresweekly&utm_medium=email)PLV8 has been extremely promising, providing all the power of JavaScript without much of the pain of SQL. It’s not without it’s faults though, though ECMAScript6 (sometimes - incorrectly - known as Harmony) actually improves a few issues and is now available in a branch of PLV8 (hopefully to land soon)._Andrew Dunstan_[Hangout on Streaming Replication in Postgres v9.4 (Sep 18)](http://www.ashnik.com/hangout-sequel-streaming-replication-in-postgres-v9-4/?utm_source=postgresweekly&utm_medium=email)Want to get the details on streaming replication for 9.4 and what it means? Tune into this hangout on September 18th when they’ll be taking a deep dive._Ashnik_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)