---
title: "How to Upgrade Postgres 10 to 11 with Zero Downtime"
publication: "Postgres Weekly"
issue: 285
published_at: "2018-12-12"
canonical_url: "https://postgresweekly.com/issues/285"
---

The latest Postgres news, articles, tools, and projects.       

#285 — December 12, 2018 

[Read on the Web](https://postgresweekly.com/issues/285)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/vwffcnrvp1sqpwocqman.jpg)](https://severalnines.com/blog/how-upgrade-postgresql10-postgresql11-zero-downtime)  

[How to Upgrade Postgres 10 to 11 with Zero Downtime](https://severalnines.com/blog/how-upgrade-postgresql10-postgresql11-zero-downtime) — The old way to accomplish upgrades on PostgreSQL used to be using `pg_upgrade`, dumping and restoring, or using some third party tools, but logical replication now opens up a reasonably painless zero downtime approach. 

Sebastian Insausti   

[How To Build a Real-Time App with GraphQL Subscriptions on Postgres](https://www.smashingmagazine.com/2018/12/real-time-app-graphql-subscriptions-postgres/) — A walkthrough of building a real-time polling app using Postgres, GraphQL, and React with no specific back-end code (it uses Hasura’s GraphQL service running on Heroku - all for free). 

Sandip Devarkonda   [![\](https://copm.s3.amazonaws.com/8c2dd309.jpg)](https://www.influxdata.com/blog/monitoring-your-postgresql-database-with-telegraf-and-influxdb/) 

[Monitoring Your PostgreSQL Database with Telegraf and InfluxDB](https://www.influxdata.com/blog/monitoring-your-postgresql-database-with-telegraf-and-influxdb/) — Learn how to monitor Postgres using InfluxDB, the fastest growing time series database built from the ground up for metrics and events. 

InfluxData sponsor   

[Keeping Postgres Tidy with Partitioning](https://blog.dataegret.com/2018/12/keeping-postgres-tidy-with-partitioning.html) — _“If you are in doubt whether partitioning is a useful tool with this one example I’m hoping you won’t wonder any further.”_ 

Alexey Lesovsky   

▶[How Does Postgres Actually Work?](https://www.youtube.com/watch?v=zkEhX0yOL3k) — It’s a year old but somehow we missed this neat talk from a Postgres core team member that digs into a lot of Postgres technicalities (particular on query parsing and planning) in a very accessible way. 

Peter Eisentraut   

[Amazon RDS Supports Publishing Postgres Logs to Amazon CloudWatch Logs](https://aws.amazon.com/about-aws/whats-new/2018/12/amazon-rds-supports-postgresql-logfiles-publish-to-amazon-cloudwatch-logs/) 

Amazon Web Services, Inc.   

[How to Performance Test Postgres Locally on macOS](https://www.peterbe.com/plog/how-i-performance-test-postgresql-locally-on-macos) — A Mozilla engineer shares how he uses pghero and Docker to performance test PG locally. 

Peter Bengtsson   

[Prepared Transactions and Their Dangers](https://www.cybertec-postgresql.com/en/prepared-transactions/) — You’re almost certainly not going to need to use _prepared transactions_ unless you’re building a transaction manager but if you’re curious.. 

Laurenz Albe   

[Allocating `work_mem` Among Sessions](https://momjian.us/main/blogs/pgblog/2018.html#December_10_2018) — `work_mem` lets you perform larger sorts in memory which, if you _have_ the memory, will trump disk-based equivalents. 

Bruce Momjian   

[Evaluating High Availability Solutions for TimescaleDB and Postgres](https://blog.timescale.com/high-availability-timescaledb-postgresql-patroni-a4572264a831) — _“How we evaluated several third-party tools and ultimately selected Patroni as our preferred method.”_ 

Lee Hampton   

[Databases vs. Encryption](https://blog.2ndquadrant.com/databases-vs-encryption/) — A look at an approach where encryption is offloaded to a separate trusted component, implemented as a custom data type, which yields some benefits over the more common options of full-disk encryption or using [pgcrypto](https://www.postgresql.org/docs/current/pgcrypto.html). 

Tomas Vondra   

[Read Our Take on What’s New in PostgreSQL 11](https://severalnines.com/blog/whats-new-postgresql-11?utm_campaign=Momentum_Campaign_DEC_2018&utm_content=pgweekly&utm_medium=Paid_Search&utm_source=banner) — Severalnines provides deployment, monitoring and management for PostgreSQL databases. 

Severalnines sponsor   

[Orafce: Oracle Compatibility Functions for Postgres](https://github.com/orafce/orafce) — Orafce implements some of the functions from Oracle database that might be useful for users migrating to Postgres. A new release last week adds support for Postgres 11. 

Orafce  

🗓 Events  

[FOSDEM PGDay 2019](https://2019.fosdempgday.org/) — **February 1, 2019 (Brussels, Belgium)** An extension to the regular PostgreSQL activities at FOSDEM.   

[PostgreSQL Conference Europe](https://2019.pgconf.eu/) — **October 15–18, 2019 (Milan, Italy)** The 11th Annual PostgreSQL Conference Europe, a day of instructor-led training followed by three days of world-class PostgreSQL presentations and a superb hallway track.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom