MIME-Version: 1.0
References: <CALvqh4r3zMTeD941M0BuXQ3C=4DgzvnxDSnrstjsoHnqiv4mqQ@mail.gmail.com>
 <CAA4eK1+2gWCRgODkv=Zvg99WJE+CCfrcHmCY9JQX7tc-VaKQjg@mail.gmail.com> <CALvqh4osSfvWShO+HkfqA-00j2MpvuRR2T-ty6vQfLHbNzvMBg@mail.gmail.com>
In-Reply-To: <CALvqh4osSfvWShO+HkfqA-00j2MpvuRR2T-ty6vQfLHbNzvMBg@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Fri, 12 Apr 2024 15:55:57 +0530
Message-ID: <CAA4eK1+jyT28a2isiyqNuqaRAneJO=mdvqarCBUUSqUurRcKPg@mail.gmail.com>
Subject: Re: pg_upgrde failed : logical replication : alter_subscription_add_log
To: Perumal Raj <perucinci@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000042145c0615e3b398"
Archived-At: <https://www.postgresql.org/message-id/CAA4eK1%2BjyT28a2isiyqNuqaRAneJO%3DmdvqarCBUUSqUurRcKPg%40mail.gmail.com>
Precedence: bulk

--00000000000042145c0615e3b398
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Note - Please keep pgsql-hackers in CC while responding.

On Fri, Apr 12, 2024 at 10:44=E2=80=AFAM Perumal Raj <perucinci@gmail.com> =
wrote:

> Thanks Amit for the update,
>
> Documentation says : https://www.postgresql.org/docs/15/upgrading.html
>
> 19.6.3. Upgrading Data via Replication
>
> It is also possible to use logical replication methods to create a standb=
y
> server with the updated version of PostgreSQL. This is possible because
> logical replication supports replication between different major versions
> of PostgreSQL. The standby can be on the same computer or a different
> computer. Once it has synced up with the primary server (running the olde=
r
> version of PostgreSQL), you can switch primaries and make the standby the
> primary and shut down the older database instance. Such a switch-over
> results in only several seconds of downtime for an upgrade.
>
> This method of upgrading can be performed using the built-in logical
> replication facilities as well as using external logical replication
> systems such as pglogical, Slony, Londiste, and Bucardo.
>
> What is "built-in logical replication" ?
>

See docs at [1].

[1] - https://www.postgresql.org/docs/devel/logical-replication.html
--
With Regards,
Amit Kapila

--00000000000042145c0615e3b398
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Note - Please keep pgsql-hackers in CC wh=
ile responding.</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Fri, Apr 12, 2024 at 10:44=E2=80=AFAM Perumal Raj &lt;<a=
 href=3D"mailto:perucinci@gmail.com">perucinci@gmail.com</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Th=
anks Amit for the update,<div><br></div><div>Documentation says :=C2=A0<a h=
ref=3D"https://www.postgresql.org/docs/15/upgrading.html" target=3D"_blank"=
>https://www.postgresql.org/docs/15/upgrading.html</a></div><div><br></div>=
<div><div style=3D"box-sizing:border-box;color:rgb(0,0,0);font-family:&quot=
;Open Sans&quot;,sans-serif;font-size:14.4px"><div style=3D"box-sizing:bord=
er-box"><div style=3D"box-sizing:border-box"><h3 style=3D"box-sizing:border=
-box;margin:1em 0px;font-weight:initial;line-height:1.2;font-size:1.4em">19=
.6.3.=C2=A0Upgrading Data via Replication</h3></div></div></div><p style=3D=
"box-sizing:border-box;margin-top:0px;margin-bottom:1rem;color:rgb(0,0,0);f=
ont-family:&quot;Open Sans&quot;,sans-serif;font-size:14.4px">It is also po=
ssible to use logical replication methods to create a standby server with t=
he updated version of=C2=A0<span style=3D"box-sizing:border-box">PostgreSQL=
</span>. This is possible because logical replication supports replication =
between different major versions of=C2=A0<span style=3D"box-sizing:border-b=
ox">PostgreSQL</span>. The standby can be on the same computer or a differe=
nt computer. Once it has synced up with the primary server (running the old=
er version of=C2=A0<span style=3D"box-sizing:border-box">PostgreSQL</span>)=
, you can switch primaries and make the standby the primary and shut down t=
he older database instance. Such a switch-over results in only several seco=
nds of downtime for an upgrade.</p><p style=3D"box-sizing:border-box;margin=
-top:0px;margin-bottom:1rem;color:rgb(0,0,0);font-family:&quot;Open Sans&qu=
ot;,sans-serif;font-size:14.4px">This method of upgrading can be performed =
using the built-in logical replication facilities as well as using external=
 logical replication systems such as=C2=A0<span style=3D"box-sizing:border-=
box">pglogical</span>,=C2=A0<span style=3D"box-sizing:border-box">Slony</sp=
an>,=C2=A0<span style=3D"box-sizing:border-box">Londiste</span>, and=C2=A0<=
span style=3D"box-sizing:border-box">Bucardo</span>.</p><p style=3D"box-siz=
ing:border-box;margin-top:0px;margin-bottom:1rem;color:rgb(0,0,0);font-fami=
ly:&quot;Open Sans&quot;,sans-serif;font-size:14.4px">What is &quot;built-i=
n logical replication&quot; ?=C2=A0</p></div></div></blockquote><div><br></=
div><div>See docs at [1].</div><div><br></div><div>[1] -=C2=A0<a href=3D"ht=
tps://www.postgresql.org/docs/devel/logical-replication.html">https://www.p=
ostgresql.org/docs/devel/logical-replication.html</a></div><div>--</div><di=
v>With Regards,</div><div>Amit Kapila</div></div></div>

--00000000000042145c0615e3b398--