El mar., 19 de feb. de 2019 a la(s) 10:05, Stephen Frost (sfrost@snowman.net) escribió:
Greetings,
* Hellmuth Vargas (hivs77@gmail.com) wrote: > But could you do the following procedure?:
> pg_upgrade of the master > rysnc with a hot standby
The above should be alright provided both the primary and the standby are down and the instructions in the pg_upgrade docs are followed.
> arracar master > hot standby start
So, start both the primary and the replica? That part should be fine by itself.
> stop hot standby and rsync the other hot standby with the migrated hot > standby?
At some later point, shut down the replica completely, then do an rsync from that replica to the other replica and build its hard-link tree that way, and update anything that's changed while the 'migrated' replica was online? I don't see any obvious issue with that as the result should mean that the two replicas are identical from PG's perspective from that point moving forward.
Ultimately, it really depends on your specific environment though, of course. It also might not be a bad idea to do a regular backup of the upgraded primary and then restore that to the second replica, just to make sure you have that whole process working and to test out your restore process.
Thanks!
Stephen
--
Cordialmente,
Ing. Hellmuth I. Vargas S. Esp. Telemática y Negocios por Internet
