From: | Daulat <daulat(dot)dba(at)gmail(dot)com> |
---|---|
To: | abbas alizadeh <ramkly(at)yahoo(dot)com> |
Cc: | Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Upgrade postgres from v10 to v14 |
Date: | 2022-01-11 14:53:05 |
Message-ID: | CALfOM6J-8coZeizjr2JmtXSS=GG=45bnffbq3vSO9XfGv_prgg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Gaurav Anand | 2022-01-11 15:09:39 | Re: Upgrade postgres from v10 to v14 |
Previous Message | abbas alizadeh | 2022-01-11 12:38:10 | Re: Upgrade postgres from v10 to v14 |