Postgres Weekly Issue 89
January 21, 2015
High Availability for PostgreSQL, Batteries Not Included
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
Christoph Schiessl
A Simple Implementation of a 'History' Table using the Hstore Extension
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
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.
AppDynamics  Sponsored
New Release: Pgloader 3.2
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
Now supports PostgreSQL 9.4.
Fish's dotNET
Postgres ODBC Driver: libpq to Govern Them All
Michael Paquier
PostgreSQL Transactions and SQLAlchemy
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
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)
If you're an avid DuckDuckGo user and excited about what we're trying to accomplish, then please consider joining us!
DuckDuckGo  Job