For an external PostgreSQL server, you need to manually create a schema called saas and a citext extension for your vRealize Automation database.

About this task

Do not perform these steps if you are using an embedded PostgreSQL database on your vRealize Automation appliances.

Prerequisites

Verify that you have recorded the vRealize Automation database name and database user. You need that information to perform this task.

Procedure

  1. If you are using an external clustered PostreSQL database, log in to the master PostgreSQL node. Otherwise, log in to your standalone external PostgreSQL node.
  2. Run the following command to manually create the required saas schema and citext extension.

    The following example uses a psql binary path for vPostgres. Your path might be different based on your operating system and the implementation of PostgreSQL that you use.

    # command to create "saas" schema and citext extension:
    su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -Atw --set ON_ERROR_STOP=on VCAC_DATABASE" << 
    EOF
    CREATE SCHEMA saas AUTHORIZATION VCAC_USER;
    CREATE EXTENSION IF NOT EXISTS "citext" SCHEMA saas;
    EOF

    Replace VCAC_DATABASE and VCAC_USER with your vRealize Automation database name and database user. The default database name and default user name are vcac.

What to do next

Download the virtual appliance upgrade. See Downloading vRealize Automation Appliance Updates.