Prepare PostgreSQL Database Before Upgrading vCenter Server - cleanup_orphaned_data_PostgresSQL.sql

Products

• VMware vCenter Server

Issue/Introduction

The cleanup script cleans and purges any unnecessary or orphaned data in your vCenter Server database that is not used by any vCenter Server component.

Here are the documents which reference the cleanup_orphaned_data_Postresql.sql which are missing from the ISO.

 

https://techdocs.broadcom.com/us/en/vmware-cis/vsphere/vsphere/7-0/vcenter-server-upgrade-7-0/migrating-vcenter-server-for-windows-to-vcenter-server-appliance/preparing-for-migration/preparing-vcenter-server-databases-for-migration/prepare-postgresql-database-before-migrating-vcenter-server-to-an-appliance.html

https://techdocs.broadcom.com/us/en/vmware-cis/vsphere/vsphere/6-7/vcenter-server-upgrade-6-7/migrating-vcenter-server-for-windows-to-vcenter-server-appliance-vCenterServerUpgrade/preparing-for-migration-vCenterServerUpgrade/preparing-vcenter-server-databases-for-migration-vCenterServerUpgrade/prepare-postgresql-database-before-migrating-vcenter-server-to-an-appliance-vCenterServerUpgrade.html

https://techdocs.broadcom.com/us/en/vmware-cis/vsphere/vsphere/6-5/vsphere-upgrade-guide-6-5/migrating-vcenter-server-for-windows-to-vcenter-server-appliance/preparing-for-migration/preparing-vcenter-server-databases-for-migration/prepare-postgresql-database-before-migrating-vcenter-server-to-an-appliance.html

Symptoms:
vCenter Server Upgrade Product Documentation asking customers to run a script which isn't available on the ISO image as outlined.

Environment

VMware vCenter Server Appliance 6.7.x
VMware vCenter Server Appliance 6.5.x
VMware vCenter Server 7.0.x

Cause

A known issue causes orphan data to be stored in the historical statistical tables.

Resolution

Please follow the product documentation for implementation of this script.

However for the Step 2.

1. For vCenter Server, locate the cleanup_orphaned_data_PostgresSQL.sql script in the ISO image and copy it to your PostgreSQL server.

Please download the script from the attachments section of this KB article.