Recently I had to upgrade a vCenter Server Appliance with embedded PSC from version 6.5 U2e to 6.7 U2c. It seemed a pretty straightforward process like the upgrades I’ve done before. But this time the upgrade failed because of an issue with the PostgreSQL database.

I examined the logfiles and found this to be the cause of the failure:

When searching for this issue on your favorite search engine you will probably be pointed to KB article 55747 and this is actually where the fix is found. However there are two critical pieces of information missing from this KB at the time of writing.

The first piece of information that is missing from the KB is that you need to execute the script on the SOURCE VCSA before you start the upgrade.

And the second piece is that the actual script that fixes the underlying issue is missing from the article. I opened a support request with GSS and they actually pointed me to a Chinese translation of the same KB article which contains the attachment. If you access the KB using the URL https://kb.vmware.com/articleview?docid=55747 there’s no attachment and if you go to https://kb.vmware.com/s/article/55747 you are redirected to another KB which also does not contain an attachment.

So for the sake of completeness I’ll share the script in this blog post as well.

After executing the script on the source VCSA the upgrade completed without any issues.

Share this if you found this interesting.

Leave a Reply

Your email address will not be published. Required fields are marked *