Re: Does PG support in place upgrade

On Wed, Apr 27, 2016 at 10:24:36AM -0400, Rakesh Kumar wrote:
> [PUsaBSKn_n] Compose (@composeio)
> 4/26/16, 1:24 PM
> You can now upgrade your #PostgreSQL 9.4 to 9.5 easily at Compose. buff.ly/
> 1WRsFFu #RDBMS
>
>
> Based on the above tweet it seems that PG has no native way of doing an inplace
> upgrade of a db. How do users upgrade db of tera byte size.

That web page mentions pg_upgrade, which allows in-place major upgrades
to happen in several minutes:

    Whichever backup you go with, it will be be restored to a new PostgreSQL
    deployment where we may, or may not, run the pg_upgrade tool.

The only _zero-downtime_ upgrade option is with logical-based
replication like Slony.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +