Re: Shortest offline window on database migration

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(dot)Winfield(at)cantabcapital(dot)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

hkerry(at)callix(dot)com(dot)br

www.callix.com.br