Ensure that your PostgreSQL database meets requirements, that you have the necessary credentials, and that you complete any necessary cleanup or other preparation before upgrading vCenter Server.
Before you begin
Verify that you have confirmed basic upgrade interoperability before preparing your PostgreSQL database for upgrading vCenter Server.
About this task
For information about backing up the vCenter Server database, see the PostgreSQL documentation.
- Verify that passwords are current and not set to expire soon.
- Locate the cleanup_orphaned_data_PostgresSQL.sql script in the ISO image and copy it to your PostgreSQL server.
- Log in to vCenter Server Appliance as root user.
- Run the cleanup script.
/opt/vmware/PostgreSQL/1.0/bin/psql -U postgres -d VCDB -f pathcleanup_orphaned_data_Postgres.sql
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.
- Make a full backup of the vCenter Server database and the vCenter Inventory Service database.
Your database is prepared for the vCenter Server upgrade.