Hello Steven, Thanks a lot for the idea, it had not thought about it. @Joshua @Tomas, thanks for clarifying why it doesn't work!
Best regards, Haroldo Kerry On Thu, May 30, 2019 at 12:54 PM Steven Winfield < steven.winfi...@cantabcapital.com> wrote: > >Has anyone been through this type of problem? > > > > You could set up a new, empty db (with checksums enabled, etc.) on the new > hardware and then use logical replication to sync across all the data from > the existing cluster. > (This logical replica could be doing binary replication to hot standbys > too, if you like). > > When the sync has finished you could perhaps gradually shift read-only > load over to the new db, and finally switch write load too - your downtime > would then be limited to how long this final cut-over takes. > > Steve. > > > > ------------------------------ > > > *This email is confidential. If you are not the intended recipient, please > advise us immediately and delete this message. The registered name of > Cantab- part of GAM Systematic is Cantab Capital Partners LLP. See - > http://www.gam.com/en/Legal/Email+disclosures+EU > <http://www.gam.com/en/Legal/Email+disclosures+EU> for further information > on confidentiality, the risks of non-secure electronic communication, and > certain disclosures which we are required to make in accordance with > applicable legislation and regulations. If you cannot access this link, > please notify us by reply message and we will send the contents to you.GAM > Holding AG and its subsidiaries (Cantab – GAM Systematic) will collect and > use information about you in the course of your interactions with us. Full > details about the data types we collect and what we use this for and your > related rights is set out in our online privacy policy at > https://www.gam.com/en/legal/privacy-policy > <https://www.gam.com/en/legal/privacy-policy>. Please familiarise yourself > with this policy and check it from time to time for updates as it > supplements this notice------------------------------ * > -- Haroldo Kerry CTO/COO Rua do Rócio, 220, 7° andar, conjunto 72 São Paulo – SP / CEP 04552-000 hke...@callix.com.br www.callix.com.br
