Re: Shortest offline window on database migration
Ian Lawrence Barwick <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAB8KJ=jxuonB6u6hFxhH3E=w-4kweRFPKz_=c0qSureAhmrBkg@mail.gmail.com> |
> 2019年5月31日(金) 6:53 Haroldo Kerry <[email protected]>: >>> On Thu, May 30, 2019 at 12:54 PM Steven Winfield <[email protected]> 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