PostgreSQL tile failing to upgrade from 10.2 to 10.2.1

Products

• VMware Tanzu for Postgres

Issue/Introduction

Upgrade of PostgreSQL tile failing from 10.2 to 10.2.1 with the following error:

Errand 'register-broker' completed with error (exit code 1)
Exit code 1
 
Instance   postgres-on-demand-broker/e0faea98-6369-47d1-a18f-ed81ea28b849  
Exit Code  1  
Stdout     [register-broker] 2025/11/25 11:03:37.453002 no valid UAA token found in cache, obtaining a new one  
           [register-broker] 2025/11/25 11:03:37.525425 obtained UAA token, expires in 3599 seconds  
           [register-broker] 2025/11/25 11:03:37.525616 GET https:<//server_name.com>/v2/service_brokers  
           [register-broker] 2025/11/25 11:03:37.603375 PUT https:<//server_name.com>/v2/service_brokers/5253c1d7-cdfd-4844-8f55-bc4b97f485f6  
           [register-broker] 2025/11/25 11:03:37.638313 failed to execute register-broker: failed to update service broker postgres-odb: unexpected response status 502; response body "{\"description\":\"Service broker catalog is invalid: \\nService names must be unique within a broker. Services with names [\\\"postgres\\\"] already exist\\n\",\"error_code\":\"CF-ServiceBrokerCatalogInvalid\",\"code\":270012}\n"  
Stderr     Error: failed to run job-process: exit status 1 (exit status 1)

Resolution

The 10.x branch does not support a direct upgrade path. As you will need to preserve your AI data, we will need to proceed with a manual migration process.

Migration Steps

• Service Backup: Back up all existing services using the "adbr" plugin.
• Tile Uninstallation: Uninstall the current tile .
• New Installation: Install the latest tile (version 10.2.1).
• Create Service: Create new services on the installed tile. We can create the service with the same name was their in 10.0
• Data Restoration: Restore the data onto the newly created services.

Note: The restoration must be performed manually, as the adbr plugin is unable to support restoration of the deleted services.

Backup and Restore with ADBR plugin