Re: Upgrade postgres from v10 to v14

This upgrade will be taken up by many this year, so kindly share any
observations, steps or workaround during the upgrade process

Thanks.

Regards,
Gaurav Anand

[image: logo] <https://bit.ly/3mj4fbp>

On Tue, Jan 11, 2022 at 8:23 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:

> Hi Abbas,
>
> Could you please share your migration steps /errors/prerequisites/post
> requisites etc.
>
> Thanks
>
> On Tue, Jan 11, 2022 at 6:08 PM abbas alizadeh <ramkly(at)yahoo(dot)com> wrote:
>
>> I recently upgrade some of our databases from 9.6 to 14.1.
>> I used pg_upgrade and there wasn’t any diffrences in code level.
>> Everything was perfect
>>
>> Best regards
>> Abbas
>>
>> On 11 Jan 2022, at 5:21 PM, Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:
>>
>> 
>> Thanks !
>>
>>
>> On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger(at)jakobs(dot)com> wrote:
>>
>>> 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
>>>
>>>

--

This communication is confidential and
subject to and governed by Saama’s 
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/>