Updating the PostgreSQL database

When you update your Spotfire Server to a newer version, any user action database logging you have configured earlier will most likely continue to work. If there are new views available, you might want to add them.

About this task

See also Update action logs and system monitoring.

Tip: If you are a familiar with SQL tools, it is probably the fastest to log in to the database spotfire_actionlog and run the SQL in create_actionlog_db.sql.

Otherwise, you can tweak the existing scripts to run the SQL.

Before you begin

You must have credentials to the action log database.

Procedure

In the new installation kit directory, browse to \scripts\postgres_install\actionlog.
Using a text editor, open the script file create_actionlog_db.bat (on Windows) or .sh (on Linux).
In the file, remove the section "Creating Spotfire Action log database user". Then, enter the information for ACTIONDB_USERNAME and ACTIONDB_PASSWORD.
Run the edited script the same way as when you enabled the database logging.
The script will only create the views that do not already exist.