RE: Shortest offline window on database migration - Mailing list pgsql-performance

From Steven Winfield
Subject RE: Shortest offline window on database migration
Date
Msg-id E9FA92C2921F31408041863B74EE4C2001BD6F949F@ccpmaildag02.cantab.local
Whole thread Raw
In response to Re: Shortest offline window on database migration  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Shortest offline window on database migration
List pgsql-performance
>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
syncacross 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
writeload too - your downtime would then be limited to how long this final cut-over takes. 

Steve.




pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Shortest offline window on database migration
Next
From: Haroldo Kerry
Date:
Subject: Re: Shortest offline window on database migration