#243: Intro to PostgreSQL Automatic Failover

.

Read this on the Web

Postgres Weekly Issue 243 — February 14, 2018

PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released 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 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 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. PostgresConf.​org    #sponsored  Introduction to PostgreSQL Automatic Failover PAF is a ‘resource agent’ that allows Pacemaker, a high availability resource manager, to interact with Postgres. Stefan Fercot An Advanced SQL Window Function Quiz “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 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 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 EnterpriseDB Training & Certification    #sponsored  Easy Postgres Performance Stats with pgHero and Docker “pgHero makes a great quick-check tool for PostgreSQL, offering results in easily consumable form” Dj Walker-Morgan Postgres's LATERAL Join Type 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 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 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 Command Prompt, Inc.​    #sponsored  pg_query: Use Postgres's SQL Parser from Ruby Lukas Fittl   #code  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK