Re: Shortest offline window on database migration

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 <hkerry(at)callix(dot)com(dot)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(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
>

--

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