Hi, If you take the route with deploying fresh VR appliances after the vCenter upgrade - this will definitely work and save you from entering the sql commands. However, please note that the n...
See more...
Hi, If you take the route with deploying fresh VR appliances after the vCenter upgrade - this will definitely work and save you from entering the sql commands. However, please note that the new VR appliances will automatically disable the old replications and when you configure the new replications, there will be some period of initial full-sync. If you use the existing .vmdks at the target site as seeds only checksum will be calculated, so the actual data transfer won't be much, but be prepared to wait for the reads for the checksum calculation. > I assume that I can't simply get the ISO for VR 6.1.1 and attempt an upgrade from the current state, but I guess I should confirm, just in case there is some kind of magic which will allow that. You first need to fix the current state before attempting upgrade to 6.x (or whatever new release). To open the SQL prompt: 1. Establish SSH session to the appliance (I don't remember if SSH is enabled or disabled by default at VR 5.8, but there should exist documented steps for enabling ssh). It will be much more easy to type the sql commands in ssh session compared to using the VM console. 2. Type /opt/vmware/vpostgresql/current/bin/psql -U vrmsdb 3. Enter each of the upgrade statements one by one followed by semicolon (;). Be careful to not paste multiple statements at once, as some of these are changing the schema, and if something fails you can retry. It might be helpful to have a second SSH session opened to browse through the sql file, or to copy it with scp and copy each individual statement via some text editor. I haven't tried if copying all the statements to a new file (without the line insert into PendingChangeRecordEntity...) and passing that file to psql would work or not. 4. Type \q to exit the sql prompt. 5. Disable the ssh access if necessary. Regards, Martin