Thank you Stephen 👍 El mar., 19 de feb. de 2019 a la(s) 10:05, Stephen Frost (sfr...@snowman.net) escribió:
> Greetings, > > * Hellmuth Vargas (hiv...@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 Oracle Database 10g Administrator Certified Associate EnterpriseDB Certified PostgreSQL 9.3 Associate