You can encounter a database error while validating the vRealize Orchestrator migration.

Problem

The validation of the vRealize Orchestrator migration fails at the Validate the source vRealize Orchestrator database server step.

Cause

If your source vRealize Orchestrator deployment uses the built-in PostgreSQL database, you might have to enable remote connections for the validation step to finish.

Solution

  1. Log in to the vRealize Orchestrator Virtual Appliance over SSH as root.
  2. Add a line to the /var/vmware/vpostgres/current/pgdata/postgresql.conf file.
    listen_addresses ='*'
  3. Restart the PostgreSQL service.
    service vpostgres restart
  4. Retry the validation.