VMware Cloud Director Object Storage Extension 1.5 introduces a change in the bucket_info table of the database. Before you upgrade VMware Cloud Director Object Storage Extension to version 1.5, prepare your database.

To prepare your database for upgrading VMware Cloud Director Object Storage Extension to VMware Cloud Director Object Storage Extension 1.5, remove the conname constraint from the bucket_info table.

Prerequisites

  • Verify that the old version of VMware Cloud Director Object Storage Extension is uninstalled.
  • Verify that you upgraded your PostgreSQL database to version 9.5 or later.
  • Verify that you backed up your database.

Procedure

  1. Log in to the PostgreSQL database as a database administrator.
  2. Retrieve the OID of the conname constraint for the bucket_info table.
    SELECT conname
    FROM pg_constraint
    WHERE conrelid =
        (SELECT oid
        FROM pg_class
        WHERE relname like 'bucket_info');
    The system returns the OID string. For example, ukb9c15fhp50s53gs8pntjaq5qt. Copy the OID so that you can use it in the next step.
  3. Remove the constraints from the bucket_info table.
    ALTER TABLE bucket_info
           DROP CONSTRAINT IF EXISTS {OID};
  4. (Optional) Delete the tables that are not used in VMware Cloud Director Object Storage Extension 1.5.
    DROP TABLE IF EXISTS um_storage_can_id;
     
    DROP TABLE IF EXISTS um_storage_user_id;
     
    DROP TABLE IF EXISTS pwc_object_info;

Results

Your PostgreSQL database is prepared for the upgrade of VMware Cloud Director Object Storage Extension to VMware Cloud Director Object Storage Extension 1.5.