NSM5200: Messages file shows ERROR: language plpgsql does not exist

Issue

An update from v2.3.1.0259 to v2.4.4.0009 has failed.

Product Line

Pelco Video Management

Environment

NSM5200 version 2.3.1.0259 being updated to 2.4.4.0009

Cause

The plpgsql language is not present in the postgres database in version 2.3.1.0259. Use the below script to query the languages that are currently installed.

/usr/local/pgsql/bin/psql -U pelco -d nsd -c "select * from pg_language;"

Resolution

Create the language using the below script then apply the update to 2.4.4.0009.  Rerun the script above to validate the language was created. Note: Running the below script on a system that already has this language installed will not affect it.

/usr/local/pgsql/bin/psql -U postgres -d nsd -c "create language plpgsql;"