Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-10 Thread Olivier Gautherot
On Thu, Jan 9, 2020, 21:47 github kran wrote: > > > On Wed, Jan 8, 2020 at 11:03 PM Michael Lewis wrote: > >> On Wed, Jan 8, 2020 at 8:52 PM github kran wrote: >> >>> You are right on RDS but I believe the problem is on Aurora PostgreSQL >>> where the pglogical throws an error during installati

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-09 Thread github kran
On Wed, Jan 8, 2020 at 11:03 PM Michael Lewis wrote: > On Wed, Jan 8, 2020 at 8:52 PM github kran wrote: > >> You are right on RDS but I believe the problem is on Aurora PostgreSQL >> where the pglogical throws an error during installation. Are you aware if >> this works on Aurora PostGreSQL >>

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread Michael Lewis
On Wed, Jan 8, 2020 at 8:52 PM github kran wrote: > You are right on RDS but I believe the problem is on Aurora PostgreSQL > where the pglogical throws an error during installation. Are you aware if > this works on Aurora PostGreSQL > It seems like this question should be sent to AWS support fo

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread github kran
On Wed, Jan 8, 2020 at 5:57 PM Christophe Pettus wrote: > > > > On Jan 8, 2020, at 15:56, github kran wrote: > > > > 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. > > You can use pglogical o

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread Christophe Pettus
> On Jan 8, 2020, at 15:56, github kran wrote: > > 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. You can use pglogical on RDS PostgreSQL 9.6. -- -- Christophe Pettus x...@thebuild.com

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread github kran
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

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread Michael Lewis
On Wed, Jan 8, 2020 at 7:20 AM github kran 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 exte

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-08 Thread github kran
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 ? On Tue, Jan 7, 2020 at 4:56 PM github kran wrote: > > On Tue, Dec 10, 2019 at 2:53 AM Andreas Kretschmer < > andr...@a-kretschmer.de> wrote: > >> >

Re: Upgrade PostgreSQL 9.6 to 10.6

2020-01-07 Thread github kran
On Tue, Dec 10, 2019 at 2:53 AM Andreas Kretschmer wrote: > > > Am 09.12.19 um 23:37 schrieb github kran: > > Great, thanks Andreas, So this seems to be a good feature using the > > core concept of replication. Can I use this extension and do the major > > upgrade without paying ?. > > yes, this

Re: Upgrade PostgreSQL 9.6 to 10.6

2019-12-10 Thread Andreas Kretschmer
Am 09.12.19 um 23:37 schrieb github kran: Great, thanks Andreas, So this seems to be a good feature using the core concept of replication. Can I use this extension and do the major upgrade without paying ?. yes, this extension is free. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Sup

Re: Upgrade PostgreSQL 9.6 to 10.6

2019-12-09 Thread github kran
Great, thanks Andreas, So this seems to be a good feature using the core concept of replication. Can I use this extension and do the major upgrade without paying ?. On Mon, Dec 9, 2019 at 10:02 AM Andreas Kretschmer wrote: > > > Am 09.12.19 um 16:43 schrieb github kran: > > Hello PostgreSQL Team

Re: Upgrade PostgreSQL 9.6 to 10.6

2019-12-09 Thread Andreas Kretschmer
Am 09.12.19 um 16:43 schrieb github kran: Hello PostgreSQL Team, I would like to know what would be the best way to do Database migration from PostgreSQL 9.6 engine to 10.6 by creating a new cluster in 10.6 and then copy data. Size of the cluster is 3.8 TB. 1) It would be a new cluster we