Re: Upgrade PostgreSQL 9.6 to 10.6
github kran <[email protected]> Wed, 8 Jan 2020 17:56:09 -0600
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CACaZr5QFT_EFqTnBXZ0S0GA01V6cC=QxneSQmOE4rytvYRNDtw@mail.gmail.com> |
--000000000000a27624059ba9a3fb Content-Type: text/plain; charset="UTF-8" Great I see its supported based on the link but the problem is we are locked into a Aurora RDS and we can't use logical replication on that engine. Any thoughts that we can use some alternate mechanism to migrate the delta data from database 1 ( Running 9.6) to database 2 ( Running 10.6 ) after we do the pg_dump and pg_restore ?. On Wed, Jan 8, 2020 at 10:25 AM Michael Lewis <[email protected]> wrote: > On Wed, Jan 8, 2020 at 7:20 AM github kran <[email protected]> wrote: > >> Sorry for the confusion, I tried to install this extension on 9.6 and it >> seems to be not working. Does 9.6 PostGreSQL supports logical replication ? >> > > > No. See the top of this page with supported versions listed. Prior to v10, > pg_logical extension was often used. > https://www.postgresql.org/docs/current/logical-replication.html > --000000000000a27624059ba9a3fb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Great I see its supported based on the link but the proble= m is we are locked into a Aurora RDS and we can't use logical replicati= on on that engine. Any thoughts that we can use some alternate mechanism to= =C2=A0<div>migrate the delta data from database 1 ( Running 9.6) to databas= e 2 ( Running 10.6 ) after we do the pg_dump and pg_restore ?.</div></div><= br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed,= Jan 8, 2020 at 10:25 AM Michael Lewis <<a href=3D"mailto:mlewis@entrata= .com">[email protected]</a>> wrote:<br></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"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jan 8, 20= 20 at 7:20 AM github kran <<a href=3D"mailto:[email protected]" targe= t=3D"_blank">[email protected]</a>> wrote:<br></div><div class=3D"gma= il_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8= ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr= "><div>Sorry for the confusion, I tried to install this extension on 9.6 an= d it seems to be not working. Does 9.6 PostGreSQL supports logical replicat= ion ?=C2=A0</div></div></blockquote><div><br></div><div><br></div><div>No. = See the top of this page with supported versions listed. Prior to v10, pg_l= ogical extension was often used.</div><div><a href=3D"https://www.postgresq= l.org/docs/current/logical-replication.html" target=3D"_blank">https://www.= postgresql.org/docs/current/logical-replication.html</a>=C2=A0</div></div><= /div> </blockquote></div> --000000000000a27624059ba9a3fb--