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@xxxxxxxxxx> 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 + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
