From: | Holger Jakobs <holger(at)jakobs(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrade postgres from v10 to v14 |
Date: | 2022-01-11 08:50:13 |
Message-ID: | 20b47ce4-6c68-602f-98e3-fe025a2e6d94@jakobs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Daulat | 2022-01-11 09:21:05 | Re: Upgrade postgres from v10 to v14 |
Previous Message | Daulat | 2022-01-11 08:44:55 | Upgrade postgres from v10 to v14 |