Date: Mon, 28 Jan 2019 09:43:46 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Mariel Cherkassky <mariel.cherkassky@gmail.com>,
	pgsql-performance@lists.postgresql.org
Subject: Re: upgrade from 9.6 to 10/11
Message-ID: <20190128154346.GM13248@telsasoft.com>
References: 
 <CA+t6e1nyjp0odTX9DuDpt4hZQk7+F51_=MitRnJSiaVZbZZpdg@mail.gmail.com>
 <f781279f4e4ef2ea8d51536140daa82f3fc9de52.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <f781279f4e4ef2ea8d51536140daa82f3fc9de52.camel@cybertec.at>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

On Mon, Jan 28, 2019 at 11:20:28AM +0100, Laurenz Albe wrote:
> Mariel Cherkassky wrote:
> > I'm planning our db upgrade from 9.6. Basically I wanted to check how stable
> > is pg11 version. I'm considering upgrading from 9.6 to 10 and then to 11 immediatly.
> > Is there a way to upgrade directly to 11 and jump on 10.
> 
> v11 is stable, else the PGDG would not release it.
> 
> There is no need to upgrade via v10, I recommend that you upgrade from 9.6
> to v11 directly, either via dump/restore or with pg_upgrade.

Keep in mind that v11.2 will be released in 2 weeks, you should plan to install
the minor upgrade to it shortly after it's released, or perhaps defer upgrading
to 11 until then.

https://www.postgresql.org/developer/roadmap/

Justin