---
title: "This Week's PostgreSQL News (#153)"
publication: "Postgres Weekly"
issue: 153
published_at: "2016-04-20"
canonical_url: "https://postgresweekly.com/issues/153"
---

Postgres Weekly 153   . 

[Read this on the Web](http://postgresweekly.com/issues/153) 

[Postgres Weekly](http://postgresweekly.com) Issue 153 — April 20, 2016     

[pgBackRest: Reliable PostgreSQL Backup and Restore System](http://www.pgbackrest.org/?utm_source=postgresweekly&utm_medium=email)Another option to help you automate and manage your backup and restore processes. Just released as a 1.00 release, it has a great group of Postgres community members behind it. The PostgreSQL Global Development Group [PostgreSQL Streaming Replication in 10 Minutes](http://hunleyd.github.io/PostgreSQL-Streaming-Replication-In-10-Minutes/?utm_source=postgresweekly&utm_medium=email)Setting up Postgres replication isn’t a new thing, but if you’re looking for the ‘cliff notes’ version, here’s what you need to get up and running. Douglas J Hunley#tutorial [Postgres-XL 9.5 R1 Released](http://www.postgres-xl.org/2016/04/postgres-xl-9-5-r1-released/?utm_source=postgresweekly&utm_medium=email)XL is a Postgres fork offering massively-parallel functionality for BI and OLTP style workloads. Postgres-XL#news [Auto-generated APIs for any database](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=tryit)Powerful API automation for standardization, portability, and scale. Free dev environment for testing and rapid prototyping. DreamFactory#sponsored[![\](https://copm.s3.amazonaws.com/020597e5.png)](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=tryit) [Amazon RDS for PostgreSQL Now Supports 9.5](http://www.postgresql.org/about/news/1659/?utm_source=postgresweekly&utm_medium=email) Kevin Jernigan#news [Could PostgreSQL 9.5 Be Your Next JSON Database?](https://compose.io/articles/could-postgresql-9-5-be-your-next-json-database/?utm_source=postgresweekly&utm_medium=email)A look at the history, before concluding “It may not be your next JSON database, but PostgreSQL could well be the next database you use to work with relational and JSON data side by side.” Dj Walker-Morgan#opinion [Secure Signed Cookies with PostgreSQL's pgcrypto](http://www.meetspaceapp.com/2016/04/19/cookie-signing-postgresql.html?utm_source=postgresweekly&utm_medium=email)Generate and verify signed cookies from a webapp using just PostgreSQL’s pgcrypto library. Nick Gauthier#tutorial [BedquiltDB: An Extended JSON Document API for PostgreSQL](https://bedquiltdb.github.io/?utm_source=postgresweekly&utm_medium=email)An open-source extension and set of libraries that wraps the jsonb data type in a slick API inspired by NoSQL document stores. Shane Kilkelly#code [Postgres 9.6 Feature: Multiple Synchronous Standbys](http://michael.otacoo.com/postgresql-2/postgres-9-6-feature-highlight-multi-sync-rep/?utm_source=postgresweekly&utm_medium=email)Currently with HA in Postgres you have a single standby you rely on. From an availability perspective this gets much better in 9.6 allowing you to support multiple synchronous standbys. Michael Paquier#news [PGInsight: CLI Tool to Dig Inside Your Postgres Databases](http://pginsight.io/?utm_source=postgresweekly&utm_medium=email)Easily dig deep inside your Postgresql database. Features include finding index information, disk usage, slow queries, cache hits and more. Khalid Lafi#tools [Using Postgres' Hstore Datatype in Rails](https://alybadawy.com/blog/2016-04-15/Using-Postgres-Hstore-datatype-in-Rails/?utm_source=postgresweekly&utm_medium=email)Hstore, a key-value store directly in Postgres, was the first NoSQL data-type to be associated with the database. Like many Postgres features you don’t have to interact with only SQL you can take advantage in a higher level framework like shown here with Rails. Aly Badawy [PostgreSQL 24/7 Support. Enterprise-class support for companies of every size.](http://2ndquadrant.com/support?utm_source=postgresweekly&utm_medium=email)The only service to guarantee a response within 15 minutes and a bug fix within 24 hours. [Request a quote today.](http://2ndquadrant.com/support) 2ndQuadrant#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/153) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK