Re: Shortest offline window on database migration

> 2019年5月31日(金) 6:53 Haroldo Kerry <hkerry@callix.com.br>:
>>> On Thu, May 30, 2019 at 12:54 PM Steven Winfield <Steven.Winfield@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
replicationto 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
switchwrite 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