---
title: "#214: How to Use Ansible to Manage Postgres "
publication: "Postgres Weekly"
issue: 214
published_at: "2017-07-05"
canonical_url: "https://postgresweekly.com/issues/214"
---

Postgres Weekly 214   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 214 — July 5, 2017     

[Analyzing Ethereum, Bitcoin, and 1200+ Cryptocurrencies](https://blog.timescale.com/analyzing-ethereum-bitcoin-and-1200-cryptocurrencies-using-postgresql-3958b3662e51?utm_source=postgresweekly&utm_medium=email)Cryptocurrencies are fuelling a modern day gold rush. How can we use Postgres and some SQL to better understand this evolving market? Timescale [How to Use Ansible to Manage Postgres](https://opensource.com/article/17/6/ansible-postgresql-operations?utm_source=postgresweekly&utm_medium=email)Ansible, an open source automation tool, can make complex configuration and management tasks in Postgres simple. Opensource [Postgres-XL: MPP and Horizontally Scalable PostgreSQL from 2ndQuadrant](https://2ndquadrant.com/en/resources/postgres-xl/)Postgres-XL is a massively parallel database built on top of and very closely compatible with PostgreSQL 9.5. It is flexible enough to handle OLAP & OLTP workloads and is Horizontally Scalable with all the features of PostgreSQL. 2ndQuadrant PostgreSQL Products#sponsored[![\](https://copm.s3.amazonaws.com/f063b131.jpg)](https://2ndquadrant.com/en/resources/postgres-xl/) [Announcing PGConf Austin 2017 — Call for Papers Open](http://blog.pgconf.us/2017/06/announcing-pgconf-austin-2017-call-for.html?utm_source=postgresweekly&utm_medium=email)It’s being held November 3-4 and the CFP is open till August 20. Joshua Drake#news [Uptown Func: Uses for Postgres Functions](https://blog.2ndquadrant.com/pg-phriday-uptown-func/?utm_source=postgresweekly&utm_medium=email)_“creating a set-returning function in Postgres is almost frighteningly trivial when compared to other database engines”_ Shaun Thomas [Efficient Rollup Tables with HyperLogLog](https://www.citusdata.com/blog/2017/06/30/efficient-rollup-with-hyperloglog-on-postgres/?utm_source=postgresweekly&utm_medium=email)Part two of a [series](https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/), this one looks at how HyperLogLog can be combined in various ways to give you more efficient rollups for dashboards and metrics. citusdata [Postgres and the Calendar](http://tapoueh.org/blog/2017/06/postgresql-and-the-calendar/?utm_source=postgresweekly&utm_medium=email)Working with calendars can be surprisingly frustrating from various formats to dealing with the nuance of leap years. Postgres yet again can do much of the hard work for you as shown here. Dimitri Fontaine [Migrating Oracle Databases to Postgres on Amazon RDS](https://selectstar.io/blog/migrating-oracle-databases-postgresql-amazon-rds/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=PostgresRDS_Blog)See how to migrate to PostgreSQL on RDS in three steps SelectStar#sponsored [Postgres Open Silicon Valley's Line-Up: A First Take](http://www.craigkerstiens.com/2017/07/01/postgresopen-sv-line-up/?utm_source=postgresweekly&utm_medium=email) Craig Kerstiens#opinion [Playing with Unicode](http://tapoueh.org/blog/2017/07/playing-with-unicode/?utm_source=postgresweekly&utm_medium=email)Crafting SQL queries to return ‘Regional Indicator Symbols’ which are formed as special combination of Unicode characters. Dimitri Fontaine [What is 'SKIP LOCKED' for in Postgres 9.5?](https://blog.2ndquadrant.com/what-is-select-skip-locked-for-in-postgresql-9-5/?utm_source=postgresweekly&utm_medium=email)A year old but has become popular on social media again this week. Craig Ringer [An Intro to PostgreSQL in 45 Minutes from PGConf US](https://pgconf.us/conferences/2017/program/proposals/intro-to-postgresql?utm_source=postgresweekly&utm_medium=email) Joe Conway#video    

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