smart reporter

databases and versions

SmartReporter Database Management This release can use one of these SQL databases:

• MySQL - When you upgrade from R75.40 or earlier to R77, SmartReporter continues to use the legacy • MySQL database. In some cases, upgrading from R75.20 or R75.40 can also use MySQL.

PostgreSQL - All new installations of SmartReporter, from R75.40VS and higher, use the PostgreSQL database. You do database management operations in these ways:

• With the SmartReporter Database Maintenance view • With CLI commands. MySQL and PostgreSQL have different commands and procedures • Changing SmartReporter configuration files

To see which SQL database is installed, run:

grep DefaultDatabase $CPDIR/registry/HKLM_registry.data

If the command returns the string PostgreSQL, the database is PostgreSQL. If the command returns another result, the database is MySQL.

connecting to postgresql database $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database

==rmdstop -server to stop