Hello Steven, Unfortunately logical replication is a pg10+ feature. One more reason for upgrading from 9.6.10 :-)
Regards, Haroldo Kerry On Thu, May 30, 2019 at 1:23 PM Haroldo Kerry <hke...@callix.com.br> wrote: > 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 > -- 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
