Upgrade the Database Schema

The MMAP database schema has been updated to support new features in MMAP 12.2. If you do not wish to keep existing analytics, you can delete the database and recreate it from scratch.

To keep existing analytics for each channel and camera in the database, run the upgrade script to upgrade from version 12.1.0 to 12.2.0. The script is available in the installation at sql\postgresql\upgrade-12.1.0-12.2.0.sql. You must also run the script stored-procedures.sql.

To upgrade the database schema

  1. Run the database upgrade script, for example on Windows:

    psql.exe -f c:\mmap\sql\postgresql\upgrade-12.1.0-12.2.0.sql
              -dpostgres --username=postgres

    where the -d option specifies the name of the database to use (in this example, "postgres"), and username specifies the name of the user to use when connecting to the database. You might also need to specify the database server hostname and port if you are not using the default values.

  2. Run the script stored-procedures.sql against the database. This script is supplied in the MMAP package.

_FT_HTML5_bannerTitle.htm