---
title: "#243: Intro to PostgreSQL Automatic Failover"
publication: "Postgres Weekly"
issue: 243
published_at: "2018-02-14"
canonical_url: "https://postgresweekly.com/issues/243"
---

Postgres Weekly 243   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 243 — February 14, 2018     

[PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released](https://www.postgresql.org/about/news/1829/)Releases that fix two security issues regarding partition keys and temporary files, plus fixes for VACUUM, GIN indexes, and hash indexes that could lead to data corruption. PostgreSQL.​org#news [Postgres Log Monitoring Basics](https://pganalyze.com/blog/postgresql-log-monitoring-101-deadlocks-checkpoints-blocked-queries.html)Postgres log files are a treasure trove of useful data to analyze to help you make your install faster. Lukas Fittl [PostgresConf US 2018: Growing the Open Source and Postgres Ecosystem](https://postgresconf.org/conferences/2018)PostgresConf US 2018 aims to provide resources for the rapidly growing Open Source and Postgres worlds through training, breakout sessions, workshops, and social events, April 16-20 at the Westin Jersey City Newport. [Register today](https://postgresconf.org/conferences/2018). PostgresConf.​org#sponsored[![\](https://copm.s3.amazonaws.com/4b0b6708.png)](https://postgresconf.org/conferences/2018) [Introduction to PostgreSQL Automatic Failover](https://pgstef.github.io/2018/02/07/introduction_to_postgresql_automatic_failover.html)[PAF](http://clusterlabs.github.io/PAF/) is a ‘resource agent’ that allows [Pacemaker](https://wiki.clusterlabs.org/wiki/Pacemaker), a high availability resource manager, to interact with Postgres. Stefan Fercot [An Advanced SQL Window Function Quiz](http://www.windowfunctions.com/)_“A lot has changed since SQL-92,”_ they say, so why not test out your knowledge. Andy Boot#tools [Securing Postgres with Let's Encrypt](https://blog.ls42.de/post/postgres-ssl-with-caddy/)Bringing together the Let’s Encrypt SSL certificate service with Postgres running inside Docker with Caddy handling the HTTP request from Let’s Encrypt. Stephan Brauer [Checking Postgres Availability with Pure Ruby](https://www.michalmlozniak.com/notes/checking-postgres-availability-with-pure-ruby.html)Play with the PG wire protocol at the lowest level, as well as do something useful with it. Michał Młoźniak [PostgreSQL 10 Associate Certification Now Available. Test Your Skills](http://inter.viewcentral.com/reg/enterprisedb/PostgreSQL10Certification) EnterpriseDB Training & Certification#sponsored [Easy Postgres Performance Stats with pgHero and Docker](https://www.compose.com/articles/easy-postgresql-performance-stats-with-pghero-and-docker/)_“[pgHero](https://github.com/ankane/pghero) makes a great quick-check tool for PostgreSQL, offering results in easily consumable form”_ Dj Walker-Morgan [Postgres's LATERAL Join Type](https://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/)A walk through a conversion funnel analysis that wasn’t possible using pure SQL in Postgres prior to version 9.3. Dan Robinson [Calculating Tupper’s Self-Referential Formula with SQL](https://blog.jooq.org/2018/02/05/calculating-tuppers-self-referential-formula-with-sql/)Geeky but very cool, with a workaround for Postgres’s lack of precision in calculations involving very large numbers. JooQ [PostgreSQL at 20TB and Beyond](https://www.slideshare.net/ChrisTravers5/postgresql-at-20tb-and-beyond)Slide that present a high level look at how one company handles analytics at a large scale on Postgres. Chris Travers [We Manage Your Data So You Can Manage Your Business: CMD 24/7 Support](https://www.commandprompt.com/) Command Prompt, Inc.​ #sponsored [pg_query: Use Postgres's SQL Parser from Ruby](https://github.com/lfittl/pg_query) Lukas Fittl#code    

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