From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Does PG support in place upgrade |
Date: | 2016-04-27 14:37:01 |
Message-ID: | 20160427143701.GA26639@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 27, 2016 at 10:30:41AM -0400, Bruce Momjian wrote:
> 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.
Oh, here are the upgrade docs about Postgres:
http://www.postgresql.org/docs/9.5/static/upgrading.html
--
Bruce Momjian <bruce(at)momjian(dot)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 +
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Westermann | 2016-04-27 14:39:48 | Re: PG 9.5.2, freetds + tds_fdw => server crash |
Previous Message | Bruce Momjian | 2016-04-27 14:30:41 | Re: Does PG support in place upgrade |