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

Postgres Weekly 193   . 

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

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

[How to Backup and Restore Postgres Databases](https://www.opsdash.com/blog/postgresql-backup-restore.html?utm_source=postgresweekly&utm_medium=email)There is more than just one method for backing up and restoring your Postgres database. This brief tutorial presents an overview of several options. RapidLoop#tutorial [Explaining 'Create Index Concurrently'](http://blog.2ndquadrant.com/create-index-concurrently/?utm_source=postgresweekly&utm_medium=email)Create Index Concurrently (CIC) is likely something you already use, but may not know how it actually manages to avoid locking the table it’s updating. Here’s a dive into how things happen under the covers when you run it. Pavan Deolasee#tutorial [Get the Health of your PostgreSQL Database checked by 2ndQuadrant experts](https://2ndquadrant.com/en/services/postgresql-healthcheck/)Prevention is better than a cure, and the same is true for your PostgreSQL database. Our experts can examine many aspects of your databases and determine the overall health in areas like performance, security, data loads, availability and compliance. 2ndQuadrant PostgreSQL Services#sponsored[![\](https://copm.s3.amazonaws.com/acc21fbb.jpg)](https://2ndquadrant.com/en/services/postgresql-healthcheck/) [On Data Loss at GitLab](http://blog.2ndquadrant.com/dataloss-at-gitlab/?utm_source=postgresweekly&utm_medium=email)Analysis and lessons to be learned from [Gitlab’s recent outage](https://www.theregister.co.uk/2017/02/01/gitlab_data_loss/?utm_source=webopsweekly&utm_medium=email) (that included several hours of data loss) from a creator of Postgres’s backup tools. Simon Riggs#news [How Honeybadger Set Up Postgres for Resiliency](http://blog.honeybadger.io/our-postgres-infrastructure/?utm_source=postgresweekly&utm_medium=email)Many people run their own Postgres instance, but don’t often share the details of their setup, but here’s a look at how Honeybadger sets things up for data resiliency. Benjamin Curtis [Performing Parallel Queries and Phrase Searching with Amazon RDS for PostgreSQL 9.6.1](https://aws.amazon.com/blogs/database/performing-parallel-queries-and-phrase-searching-with-amazon-rds-for-postgresql-9-6-1/?utm_source=postgresweekly&utm_medium=email) Amazon#tutorial [Continuous Postgres Backup Tests with Docker](https://lolware.net/2017/02/02/continuous-backup-tests-with-docker.html?utm_source=postgresweekly&utm_medium=email)Create a Docker container that installs Postgres 9.6, loads in a database backup, and tests it. lolware#tutorial [PostGraphQL: PostgreSQL meets GraphQL](https://www.compose.com/articles/postgraphql-postgresql-meets-graphql/?utm_source=cooper&utm_medium=newsletter&utm_content=postgresql)An introductory article on how to get up-and-running with GraphQL and PostgreSQL for working with databases on the web. Compose#tutorial#sponsored [Advanced SQL Recipes](http://www.silota.com/docs/recipes/?utm_source=postgresweekly&utm_medium=email)A (growing) compendium of advanced SQL tricks you can adopt to jump-start your next analysis. Silota [WAL-E: Simple Continuous Archiving for Postgres](https://github.com/wal-e/wal-e?utm_source=postgresweekly&utm_medium=email)The most important task for your database is keeping your data safe, continuous archiving is one of the tools every database should have. Wal-e is a simple tool for helping with that, and in fact it powers continuous archiving for all of Heroku Postgres. GitHub#code [PostgreSQL 9.5 in a Vagrant Box](https://github.com/HarryR/vagrant-psql?utm_source=postgresweekly&utm_medium=email)A work in progress but it’s ready to play with. Harry Roberts#code    

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