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

Postgres Weekly 192   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 192 — February 1, 2017     

[pgwatch2: A Simple But Versatile Postgres Monitoring Tool](http://www.cybertec.at/announcing-pgwatch2-a-simple-but-versatile-postgresql-monitoring-tool/?utm_source=postgresweekly&utm_medium=email)There is no shortage of database monitoring tools, but that doesn’t mean new ones don’t have their place. Pgwatch doesn’t require an agent and comes with some good out of the box insights for monitoring your database. Kaarel Moppel#tools [GitLab's Database Incident](https://docs.google.com/document/d/1GCK53YDcBWQveod9kfzW-VCxIABGiryG7_z_6jHdVik/pub?utm_source=postgresweekly&utm_medium=email)A very transparent timeline and retrospective of a database incident involving Postgres, resulting in a multi-hour outage of the code hosting site. GitLab [PostGIS 2.3.2 & 2.2.5: Spatial and Geographic Objects for Postgres](http://postgis.net/2017/01/31/postgis-2.3.2/?utm_source=postgresweekly&utm_medium=email)The focus is on bug fixes and patches in both cases. [2.2.5 here.](http://postgis.net/2017/01/30/postgis-2.2.5/) PostGIS Developers [Clever Cloud: The End of Server Management](https://www.clever-cloud.com/postgresql?utm_source=newsletter&utm_campaign=cooperpress-sponsored-link-early2017&utm_medium=email&utm_content=postgresql)Cloud hosting for developers by developers. Polyglot and scalable, saving thousands of souls from server management since 2010 in America and Europe. Clever Cloud#sponsored[![\](https://copm.s3.amazonaws.com/1539e112.png)](https://www.clever-cloud.com/postgresql?utm_source=newsletter&utm_campaign=cooperpress-sponsored-link-early2017&utm_medium=email&utm_content=postgresql) [Postgres 10 Highlight: Compression Support in pg_receivexlog](http://paquier.xyz/postgresql-2/postgres-10-pgreceivexlog-compression/?utm_source=postgresweekly&utm_medium=email)On-the-fly zlib compression and .gz file storage of WAL records. Michael Paquier#news [Inserting JSONB Data in Postgres 9.6](http://blog.2ndquadrant.com/inserting-jsonb-data-in-postgresql-9-6/?utm_source=postgresweekly&utm_medium=email) Rubens Souza#tutorial [What Does pg_start_backup() Do?](http://blog.2ndquadrant.com/what-does-pg_start_backup-do/?utm_source=postgresweekly&utm_medium=email) Simon Riggs#tutorial [A Potential Postgres Case-Sensitivity Tripping Point](https://blog.xojo.com/2016/09/28/about-postgresql-case-sensitivity/?utm_source=postgresweekly&utm_medium=email)Postgres can appear case-insensitive to table or column names in many situations, but sometimes you’ll encounter a subtlety of how it really works. Paul Lefebvre#tutorial [pgBadger v9.1: A PostgreSQL Performance Analyzer](https://www.postgresql.org/about/news/1730/?utm_source=postgresweekly&utm_medium=email) postgresql.​org#tools [Getting Started with GitHub Event Data on Citus](https://www.citusdata.com/blog/2017/01/27/getting-started-with-github-events-data/?utm_source=postgresweekly&utm_medium=email)Getting an example dataset to test out a new database can be as much work as trying the database itself. This example uses GitHub data to guide through how Citus and sharding works. Citus Data#code [postpy: Utilities for ETL and Data Analysis from Python](https://github.com/portfoliome/postpy?utm_source=postgresweekly&utm_medium=email) Censible#code [DreamFactory REST API platform for Postgres](https://www.dreamfactory.com/signup)Develop apps faster. DreamFactory automatically turns Postgres into a REST API platform in minutes. DreamFactory#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/192) [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