MIME-Version: 1.0
References: <7af5c98d-e547-4caa-b275-441c80dbe6c9@app.fastmail.com>
In-Reply-To: <7af5c98d-e547-4caa-b275-441c80dbe6c9@app.fastmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 9 Dec 2024 08:06:47 -0500
Message-ID: <CAKAnmm+YkjX+Mvx6QOj0+3n-=jO_DiMNASLEBmHFnPe6KeErJA@mail.gmail.com>
Subject: Re: pg_upgrade vs. logical replication
To: Joe Wildish <joe@lateraljoin.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000aa56550628d60b6f"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BYkjX%2BMvx6QOj0%2B3n-%3DjO_DiMNASLEBmHFnPe6KeErJA%40mail.gmail.com>
Precedence: bulk

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

On Mon, Dec 9, 2024 at 6:43=E2=80=AFAM Joe Wildish <joe@lateraljoin.com> wr=
ote:
Overall, your solution seems okay, but:


> a fix has gone in to PG17 that sorts this problem.
>


> However, we can't go to 17 yet, so need a solution for 15 and 16.


Honestly, this would seem like a really, really strong reason to push for
v17.

Cheers,
Greg

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Dec 9, 2024 at 6:43=E2=80=AFAM Jo=
e Wildish &lt;<a href=3D"mailto:joe@lateraljoin.com">joe@lateraljoin.com</a=
>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><div>Ove=
rall, your solution seems okay, but:</div><div>=C2=A0</div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">a fix has gone in to PG17 that sorts this=
 problem.<br></blockquote><div>=C2=A0</div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">
However, we can&#39;t go to 17 yet, so need a solution for 15 and 16.</bloc=
kquote><div><br></div><div>Honestly, this would seem like a really, really =
strong reason to push for v17.</div><div><br></div><div>Cheers,</div><div>G=
reg</div><div><br></div></div></div>

--000000000000aa56550628d60b6f--