---
title: "#233: Upgrading From 9.6 to 10 with Minimal Downtime using pglogical"
publication: "Postgres Weekly"
issue: 233
published_at: "2017-11-15"
canonical_url: "https://postgresweekly.com/issues/233"
---

Postgres Weekly 233   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 233 — November 15, 2017      

Just a quick heads up that we're taking a break for Thanksgiving next week, so the next issue will be on Wednesday, November 29. In the meantime, there's a heavy focus on ways to upgrade from Postgres 9.x to 10 this week, so if you get bored next week at all.. :-) 

[Upgrading From 9.6 to 10 with Minimal Downtime using pglogical](https://rosenfeld.herokuapp.com/en/articles/infrastructure/2017-11-10-upgrading-postgresql-from-9-6-to-10-with-minimal-downtime-using-pglogical)One approach of using pglogical to switch from 9.6 to 10 in ‘just a few seconds’. Rodrigo Rosenfeld Rosas 

[How to Scale PG 10 with Table Inheritance & Declarative Partitioning](https://blog.timescale.com/scaling-partitioning-data-postgresql-10-explained-cd48a712a9a1)One of the more exciting new features in Postgres 10 is declarative partitioning. This can make it easier to scale to ‘big data’ volumes. Timescale 

[Advanced SQL: A Look Through Window Functions](http://mjk.space/advanced-sql-window-functions/)A thorough, Postgres-flavored exploration of window functions, ideal if you’re not particularly familiar with them. Michal Konarski 

[24/7 PostgreSQL Support From the Experts That Wrote the Code](https://2ndquadrant.com/en/support/support-postgresql/)When it's critical, you can count on us. Who better to support your database around-the-clock than the experts who developed the PostgreSQL features you're using? We guarantee a quick database recovery with as little downtime as possible. 2ndQuadrant PostgreSQL Services#sponsored — [![\](https://copm.s3.amazonaws.com/3bcc825a.jpg)](https://2ndquadrant.com/en/support/support-postgresql/) 

[Migrating Partitioned Tables to Postgres 10's Native Partitioning](https://www.openscg.com/2017/11/migrating-partitioned-tables-to-postgresql-10s-native-partitioning/) Jobin Augustine 

[An Alternative Way of Upgrading to Native Partitioning](http://blog.postgresql-consulting.com/2017/11/upgrading-inheritance-partitioning-made.html)A post inspired by the one above but which takes a different approach, not involving dumping and restoring tables. Alexey Lesovsky 

[PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 Released](https://www.postgresql.org/about/news/1801/)These releases fix three security vulnerabilities, and patch a few minor bugs. postgresql.​org#news 

[The Mode Ordered-Set Aggregate Function](http://tapoueh.org/blog/2017/11/the-mode-ordered-set-aggregate-function/)A way to find the most frequent input value in a group. Dimitri Fontaine 

[Postgres Primary/Replica Replication on Heroku with Ruby on Rails](https://medium.com/kkempin/postgresql-master-slave-replication-on-heroku-with-ruby-on-rails-bf0eb8d69fe) Krzysztof Kempiński 

[Faster Bulk Loading in Postgres with 'Copy'](https://www.citusdata.com/blog/2017/11/08/faster-bulk-loading-in-postgresql-with-copy/)`\copy` is a mechanism for you to bulk load data in or out of Postgres. citusdata 

[From 0 to ~100: Business Continuity with PostgreSQL](https://www.slideshare.net/GabrieleBartolini/from-0-to-100-business-continuity-with-postgresql/1)A run through combinations of disaster recovery and high availability processes/architectures that you can use with PostgreSQL. Gabriele Bartolini 

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://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. Get $20 credit on a new account. Linode Cloud Hosting#sponsored 

[OmniDB 2.3: A Browser-Based Postgres Management Tool](https://www.postgresql.org/about/news/1799/)The new version includes a debugger for PL/pgSQL functions. 2nd Quadrant#tools     

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