pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade postgres from v10 to v14
6+ messages / 4 participants
[nested] [flat]
* Upgrade postgres from v10 to v14
@ 2022-01-11 08:44 Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2022-01-11 08:44 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
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,
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrade postgres from v10 to v14
@ 2022-01-11 08:50 Holger Jakobs <holger@jakobs.com>
parent: Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Holger Jakobs @ 2022-01-11 08:50 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrade postgres from v10 to v14
@ 2022-01-11 09:21 Daulat <daulat.dba@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2022-01-11 09:21 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks !
On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrade postgres from v10 to v14
@ 2022-01-11 12:38 abbas alizadeh <ramkly@yahoo.com>
parent: Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: abbas alizadeh @ 2022-01-11 12:38 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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.dba@gmail.com> wrote:
>
>
> Thanks !
>
>
>> On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.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
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrade postgres from v10 to v14
@ 2022-01-11 14:53 Daulat <daulat.dba@gmail.com>
parent: abbas alizadeh <ramkly@yahoo.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2022-01-11 14:53 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; +Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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@yahoo.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.dba@gmail.com> wrote:
>
>
> Thanks !
>
>
> On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.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
>>
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrade postgres from v10 to v14
@ 2022-01-11 15:09 Gaurav Anand <gaurav.anand@saama.com>
parent: Daulat <daulat.dba@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Gaurav Anand @ 2022-01-11 15:09 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: abbas alizadeh <ramkly@yahoo.com>; Holger Jakobs <holger@jakobs.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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.dba@gmail.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@yahoo.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.dba@gmail.com> wrote:
>>
>>
>> Thanks !
>>
>>
>> On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.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/;
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2022-01-11 15:09 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-01-11 08:44 Upgrade postgres from v10 to v14 Daulat <daulat.dba@gmail.com>
2022-01-11 08:50 ` Holger Jakobs <holger@jakobs.com>
2022-01-11 09:21 ` Daulat <daulat.dba@gmail.com>
2022-01-11 12:38 ` abbas alizadeh <ramkly@yahoo.com>
2022-01-11 14:53 ` Daulat <daulat.dba@gmail.com>
2022-01-11 15:09 ` Gaurav Anand <gaurav.anand@saama.com>
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