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
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.
stored-procedures.sql
against the database. This script is supplied in the MMAP package.
|