---
title: "#207: Postgres's May 2017 Security Update Release"
publication: "Postgres Weekly"
issue: 207
published_at: "2017-05-17"
canonical_url: "https://postgresweekly.com/issues/207"
---

Postgres Weekly 207   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 207 — May 17, 2017     

[Microsoft Launches Azure Database for Postgres](https://azure.microsoft.com/en-us/services/postgresql/?utm_source=postgresweekly&utm_medium=email)A managed, scalable Postgres database service for Microsoft’s Azure cloud. Microsoft#news [Postgres's May 2017 Security Update Release](https://www.postgresql.org/about/news/1746/?utm_source=postgresweekly&utm_medium=email)Updates to all supported versions (9.6.3, 9.5.7, 9.4.12, 9.3.17, and 9.2.21) have been released to fix 3 vulnerabilities. PostgreSQL#news [The Major Features in Postgres 10 [PDF\]](http://momjian.us/main/writings/pgsql/features.pdf?utm_source=postgresweekly&utm_medium=email)Straightforward slides covering the basics on the forthcoming release’s features. Bruce Momjian [Get the Health of your PostgreSQL Database checked by 2ndQuadrant Experts](https://www.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/71654b41.jpg)](https://www.2ndquadrant.com/en/services/postgresql-healthcheck/) [Incompatible Changes in Postgres 10](http://paquier.xyz/postgresql-2/postgres-10-incompatible-changes/?utm_source=postgresweekly&utm_medium=email)It’s still not out but there are a small variety of incompatible changes coming to Postgres 10 to be aware of before upgrading. Michael Paquier#news [How to Map Users, Roles, and Grants from Oracle to Postgres](https://aws.amazon.com/blogs/database/use-sql-to-map-users-roles-and-grants-from-oracle-to-postgresql/?utm_source=postgresweekly&utm_medium=email)Amazon are only happy to help you move from Oracle to Postgres. Amazon Web Services [3 Powerful Uses for SQL's 'DISTINCT' in Postgres](https://medium.com/@hakibenita/the-many-faces-of-distinct-in-postgresql-c52490de5954?utm_source=postgresweekly&utm_medium=email) Haki Benita [Postgres Window Magic [PDF\]](http://momjian.us/main/writings/pgsql/window.pdf?utm_source=postgresweekly&utm_medium=email)An explanation of Postgres’ many window function facilities and how they can be used to produce useful query results. Bruce Momjian [Postgres Full-Text Search With Django](http://blog.lotech.org/postgres-full-text-search-with-django.html?utm_source=postgresweekly&utm_medium=email)Full text search in Postgres hasn’t always been easy to leverage from within frameworks. With Django 1.10 the support is much more built-in. Lotechnica [PostgREST API Starter Kit: For Building Data API Backends](https://github.com/subzerocloud/postgrest-starter-kit?utm_source=postgresweekly&utm_medium=email)Boilerplate and a set of tools for building Postgres-backed APIs using [PostgREST](https://postgrest.com/en/v0.4/) and Docker. subZero#tools [pg_chameleon 1.1: A MySQL to Postgres Replication System](https://github.com/the4thdoctor/pg_chameleon?utm_source=postgresweekly&utm_medium=email) Federico Campoli#tools [Linux cloud hosting starting at 1GB of RAM for $5/mo.](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. linode#sponsored    

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