From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
---|---|
To: | Haroldo Kerry <hkerry(at)callix(dot)com(dot)br> |
Cc: | Steven Winfield <Steven(dot)Winfield(at)cantabcapital(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Shortest offline window on database migration |
Date: | 2019-05-31 02:49:44 |
Message-ID: | CAB8KJ=jxuonB6u6hFxhH3E=w-4kweRFPKz_=c0qSureAhmrBkg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> 2019年5月31日(金) 6:53 Haroldo Kerry <hkerry(at)callix(dot)com(dot)br>:
>>> 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.
> Hello Steven,
> Unfortunately logical replication is a pg10+ feature. One more reason for upgrading from 9.6.10 :-)
Have you looked at the pglogical extension from 2ndQuadrant?
https://github.com/2ndQuadrant/pglogical/tree/REL2_x_STABLE
Regards
Ian Barwick
--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2019-05-31 09:40:54 | Re: Shortest offline window on database migration |
Previous Message | Jeff Janes | 2019-05-31 01:41:50 | Re: Shortest offline window on database migration |