Message-ID: <f781279f4e4ef2ea8d51536140daa82f3fc9de52.camel@cybertec.at>
Subject: Re: upgrade from 9.6 to 10/11
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>,
	pgsql-performance@lists.postgresql.org
Date: Mon, 28 Jan 2019 11:20:28 +0100
In-Reply-To: 
 <CA+t6e1nyjp0odTX9DuDpt4hZQk7+F51_=MitRnJSiaVZbZZpdg@mail.gmail.com>
References: 
	<CA+t6e1nyjp0odTX9DuDpt4hZQk7+F51_=MitRnJSiaVZbZZpdg@mail.gmail.com>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

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.

https://www.postgresql.org/docs/current/upgrading.html

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com