Re: [GENERAL] Does PG support in place upgrade

2016-04-27 Thread Bruce Momjian 
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  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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Does PG support in place upgrade

2016-04-27 Thread Bruce Momjian 
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  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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Does PG support in place upgrade

2016-04-27 Thread Rakesh Kumar 
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. 

--
Sent from mobile.