An update from v2.3.1.0259 to v2.4.4.0009 has failed.
Pelco Video Management
NSM5200 version 2.3.1.0259 being updated to 2.4.4.0009
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;"
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;"