pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade postgres from v10 to v14
Date: Tue, 11 Jan 2022 09:50:13 +0100
Message-ID: <20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com> (raw)
In-Reply-To: <CALfOM6JRpqHyt33+pN22rg+CxUPKhX9RW9C-tJ-cNq=osy7YFQ@mail.gmail.com>
References: <CALfOM6JRpqHyt33+pN22rg+CxUPKhX9RW9C-tJ-cNq=osy7YFQ@mail.gmail.com>

Am 11.01.22 um 09:44 schrieb Daulat:
> Hello Team,
>
> We are planning to upgrade our existing Postgres v10 to  v14 .
> I need to know the best practices for upgrades and  major differences 
> between PostgreSQL v10 and v14, primarily to identify code level impact.
>
> Thanks,
>
Hello,

Have a look at https://www.postgresql.org/about/featurematrix/ for the 
differences between versions. For code level impact (which will be very 
small, maybe non-existant), you may read the release notes of the 
versions 11 thru 14.

https://www.postgresql.org/docs/11/release.html
https://www.postgresql.org/docs/12/release.html
https://www.postgresql.org/docs/13/release.html
https://www.postgresql.org/docs/14/release.html

The topic upgrading is well described at 
https://www.postgresql.org/docs/current/upgrading.html

If your database isn't large, I'd recommend pg_dump + psql, but if it's 
large, pg_upgrade is a must.

Regards,

Holger

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



Attachments:

  OpenPGP_signature (application/pgp-signature, 202B) download

view thread (6+ messages)  latest in thread

Message-ID: <20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com>
Permalink:  ../20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com/
Also on:    postgresql.org/message-id/20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Upgrade postgres from v10 to v14
  In-Reply-To: <20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox