[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: Upgrade postgres from v10 to v14
From: Gaurav Anand <gaurav.anand () saama ! com>
Date: 2022-01-11 15:21:39
Message-ID: CAMZ99neSoY-g0-FPT5ibvGLz6BwOtnzNt_x2J=8zLNYF=qKLTg () mail ! gmail ! com
[Download RAW message or body]
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/>
[Attachment #3 (text/html)]
<div dir="ltr">This upgrade will be taken up by many this year, so kindly share any \
observations, steps or workaround during the upgrade process<br \
clear="all"><div><div dir="ltr" class="gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><br></div><div>Thanks.</div><div><br></div><div>Regards,</div><div>Gaurav \
Anand</div></div></div></div></div></div><br><a href="https://bit.ly/3mj4fbp" \
target="_blank"><img \
src="https://www.saama.com/wp-content/uploads/2021/10/SVB-Journal-Funding-email-sig-420x84-1.png" \
alt="logo"></a></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Tue, Jan 11, 2022 at 8:23 PM Daulat <<a \
href="mailto:daulat.dba@gmail.com">daulat.dba@gmail.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi \
Abbas,<div><br><div>Could you please share your migration steps \
/errors/prerequisites/post requisites \
etc.</div><div><br><div>Thanks</div></div></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 11, 2022 at 6:08 PM \
abbas alizadeh <<a href="mailto:ramkly@yahoo.com" \
target="_blank">ramkly@yahoo.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="auto">I recently upgrade some of our \
databases from 9.6 to 14.1. <div>I used pg_upgrade and there wasn't any diffrences \
in code level. Everything was perfect<br><br><div dir="ltr">Best regards</div><div \
dir="ltr">Abbas</div><div dir="ltr"><br><blockquote type="cite">On 11 Jan 2022, at \
5:21 PM, Daulat <<a href="mailto:daulat.dba@gmail.com" \
target="_blank">daulat.dba@gmail.com</a>> \
wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div \
dir="ltr">Thanks ! <div><br></div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <<a \
href="mailto:holger@jakobs.com" target="_blank">holger@jakobs.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Am 11.01.22 um 09:44 \
schrieb Daulat:<br> > Hello Team,<br>
><br>
> We are planning to upgrade our existing Postgres v10 to v14 .<br>
> I need to know the best practices for upgrades and major differences <br>
> between PostgreSQL v10 and v14, primarily to identify code level impact.<br>
><br>
> Thanks,<br>
><br>
Hello,<br>
<br>
Have a look at <a href="https://www.postgresql.org/about/featurematrix/" \
rel="noreferrer" target="_blank">https://www.postgresql.org/about/featurematrix/</a> \
for the <br> differences between versions. For code level impact (which will be very \
<br> small, maybe non-existant), you may read the release notes of the <br>
versions 11 thru 14.<br>
<br>
<a href="https://www.postgresql.org/docs/11/release.html" rel="noreferrer" \
target="_blank">https://www.postgresql.org/docs/11/release.html</a><br> <a \
href="https://www.postgresql.org/docs/12/release.html" rel="noreferrer" \
target="_blank">https://www.postgresql.org/docs/12/release.html</a><br> <a \
href="https://www.postgresql.org/docs/13/release.html" rel="noreferrer" \
target="_blank">https://www.postgresql.org/docs/13/release.html</a><br> <a \
href="https://www.postgresql.org/docs/14/release.html" rel="noreferrer" \
target="_blank">https://www.postgresql.org/docs/14/release.html</a><br> <br>
The topic upgrading is well described at <br>
<a href="https://www.postgresql.org/docs/current/upgrading.html" rel="noreferrer" \
target="_blank">https://www.postgresql.org/docs/current/upgrading.html</a><br> <br>
If your database isn't large, I'd recommend pg_dump + psql, but if it's \
<br> large, pg_upgrade is a must.<br>
<br>
Regards,<br>
<br>
Holger<br>
<br>
-- <br>
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012<br>
<br>
</blockquote></div>
</div></blockquote></div></div></blockquote></div>
</blockquote></div>
<br>
<p><span style="font-size:10pt;line-height:115%;font-family:Arial,sans-serif">This \
communication is confidential and subject to and governed by Saama's</span><span \
style="font-size:9.5pt;line-height:115%;color:#222222;background:white"> </span><a \
href="https://www.saama.com/email-communication-disclaimer/" target="_blank"><span \
style="font-size:10.0pt;line-height:115%;font-family:"Arial","sans-serif"">Electronic
Communications Disclaimer</span><span \
style="font-size:9.5pt;line-height:115%;color:#1155cc;background:white">.</span></a></p>
<p> </p>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic