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 <andr...@a-kretschmer.de> wrote: > > > 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 want to create on 10.6 and then copy > > data form 9.6 and shutdown 9.6 > > 2) Cluster today contains 1 master instance and another instance for > > reader > > 3) Can this be done without a downtime ? what are the options I have > > to do this without making this complicated . We have about 30 -40 > > tables to do the migration. > > > > > > yes, you can use pg_logical from us (2ndquadrant). Please visit our > homepage, there you can find it for 9.6. There are also some > blogs-postings about all that in our blog. > > > Regards, Andreas > > -- > 2ndQuadrant - The PostgreSQL Support Company. > www.2ndQuadrant.com > > > >
