---
title: "This Week's PostgreSQL News (#89)"
publication: "Postgres Weekly"
issue: 89
published_at: "2015-01-21"
canonical_url: "https://postgresweekly.com/issues/89"
---

Postgres Weekly Issue 89 - January 21, 2015

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/89)**Postgres Weekly****Issue 89**
January 21, 2015[High Availability for PostgreSQL, Batteries Not Included](https://blog.compose.io/high-availability-for-postgresql-batteries-not-included/?utm_source=postgresweekly&utm_medium=email)Want a look at how one company which runs Postgres as a service implements their HA? Well here it is, a great look under the cover of someone else’s approach for HA._Compose_[Smarter Synchronization of your PostgreSQL Development and Production DBs](http://www.csinaction.com/2015/01/17/smarter-synchronization-of-your-postgresql-development-and-production-dbs/?utm_source=postgresweekly&utm_medium=email)_Christoph Schiessl_[A Simple Implementation of a 'History' Table using the Hstore Extension](http://okbob.blogspot.com/2015/01/most-simply-implementation-of-history.html?utm_source=postgresweekly&utm_medium=email)Lots of applications want history for their applications, and for as many times as it’s been desired implementing it is still often left up to you. Here’s a great post on how it can more easily be done with hstore._Pavel Stěhule_[A New Way to Measure Business Impact](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress=sponsorship=postgres%20weekly=a%20new%20way%20to%20measure%20business%20impact=1_21_2015?utm_source=postgresweekly&utm_medium=email)As application complexity increases, it’s important to keep a focus on what really matters to your business - your application revenue. With AppDynamics, you get 100% visibility into application revenue in real time so you can now be more effective in how you identify, isolate, and resolve application issues that affect the business. [Get started with AppDynamics.](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress=sponsorship=postgres%20weekly=a%20new%20way%20to%20measure%20business%20impact=1_21_2015)_AppDynamicsSponsored_[![\](https://copm.s3.amazonaws.com/e16c32c1.png)](https://portal.appdynamics.com/account/signup/signupForm/?utm_source=cooperpress=sponsorship=postgres%20weekly=a%20new%20way%20to%20measure%20business%20impact=1_21_2015?utm_source=postgresweekly&utm_medium=email)[New Release: Pgloader 3.2](http://tapoueh.org/blog/2015/01/16-pgloader-3-2.html?utm_source=postgresweekly&utm_medium=email)The ‘COPY’ statement is a powerful way to load data into Postgres, but it’s more like a chainsaw than a surgeon’s scalpel. Pgloader is a tool that’s meant to help with the process of loading data from other sources into Postgres with better support/error handling._Dimitri Fontaine_[Database .NET 14.0 Released](http://www.postgresql.org/about/news/1558/?utm_source=postgresweekly&utm_medium=email)Now supports PostgreSQL 9.4._Fish's dotNET_[Postgres ODBC Driver: libpq to Govern Them All](http://michael.otacoo.com/postgresql-2/postgres-odbc-driver-libpq-govern-all/?utm_source=postgresweekly&utm_medium=email)_Michael Paquier_[PostgreSQL Transactions and SQLAlchemy](http://oddbird.net/2014/06/14/sqlalchemy-postgres-autocommit/?utm_source=postgresweekly&utm_medium=email)Want to dig deeper beyond just assuming your ORM is doing what you want and learn more about how Postgres handles transactions and how it applies for your application? Here’s a deep dive with details on the two most popular Python ORMs._Oddbird_[Postgres 9.5 Feature Highlight: New WAL Format](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-new-wal-format/?utm_source=postgresweekly&utm_medium=email)Under the covers the Write-Ahead-Log or WAL is key to how Postgres reliably keeps your data. An update to the WAL for 9.5 is going to allow some even more powerful functionality to be built on it._Michael Paquier_[SRE Position at DuckDuckGo (Remote OK)](https://duck.co/help/company/hiring?utm_source=postgresweekly&utm_medium=email)If you're an avid DuckDuckGo user and excited about what we're trying to accomplish, then please consider joining us!_DuckDuckGoJob_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|*)