Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade PostgreSQL 9.6 to 10.6 - Mailing list pgsql-general

From github kran
Subject Re: Upgrade PostgreSQL 9.6 to 10.6
Date
Msg-id CACaZr5QFT_EFqTnBXZ0S0GA01V6cC=QxneSQmOE4rytvYRNDtw@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade PostgreSQL 9.6 to 10.6  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Upgrade PostgreSQL 9.6 to 10.6
List pgsql-general
Tree view
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 <mlewis@entrata.com> wrote:
On Wed, Jan 8, 2020 at 7:20 AM github kran <githubkran@gmail.com> 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.

pgsql-general by date:

Previous
From: Mike Lissner
Date:
Subject: Re: Is it safe to transfer logical replication publication/subscription?
Next
From: Christophe Pettus
Date:
Subject: Re: Upgrade PostgreSQL 9.6 to 10.6