Upgrade Consideration for PostgreSQL

Omni-Gen requires the PostgreSQL pgcrypto functions to be available. Pgcrypto is included in most PostgreSQL 8.4 and higher distributions, and is enabled for use by the following command:

CREATE EXTENSION pgcrypto;

To see if pgcrypto is available, issue the following command:

select * from pg_available_extensions

For earlier versions of PostgreSQL, or its derivatives, the appropriate pgcrypto package must be installed. Where CREATE EXTENSION is not supported, the function definitions will need to be installed manually. For example:

psql -d databasename -f $PGHOME/share/postgresql/contrib/pgcrypto.sql