From: | Haroldo Kerry <hkerry(at)callix(dot)com(dot)br> |
---|---|
To: | Steven Winfield <Steven(dot)Winfield(at)cantabcapital(dot)com> |
Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Shortest offline window on database migration |
Date: | 2019-05-30 16:23:33 |
Message-ID: | CAHxH9rOdgK3M_9NYNmgRUsQPnAqzqjcNkkJztngrkORmux671Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Haroldo Kerry | 2019-05-30 21:52:41 | Re: Shortest offline window on database migration |
Previous Message | Steven Winfield | 2019-05-30 15:54:52 | RE: Shortest offline window on database migration |