When upgrading the application, you will need to run a number of SQL statements on ApplicationDb (PostgreSQL). The statements that you need to run depend on your currently installed version.
Upgrade from release 6.2 or earlier
ALTER TABLE caf_verdefcontentdep ALTER COLUMN fromfieldpath TYPE text,
ALTER COLUMN tofieldpath TYPE text;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);Upgrade from release 7.1
CREATE EXTENSION IF NOT EXISTS pg_trgm;
ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);Upgrade from release 8.2 or newer
ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);Note: After applying schema changes, restart the application server.