Data Management

Image Studio 21 CFR Part 11 data are stored on the server.

  • Images and server log files are saved in the Server folder.
    C:\users\<windows login name>\.licor\ImageStudio\Server
  • All other data, including analysis data and metadata, are stored in a PostgreSQL database.

    The PostgreSQL System Master password is required to back up the database. LI‑COR is not responsible for maintaining the password.

Data Backup

Each customer organization is responsible for backing up data according to their own policy. LI‑COR recommends the following guidelines for backing up your data:

  • Back up the PostgreSQL database and image data in the Server folder on a routine basis.
  • Keep the database backup and Server folder backup in sync by backing both up at the same time.

Contents of the Server folder can be backed up using appropriate file management procedures, and the database can be backed up using the methods described below.

Please see the following third-party guide for more information about using the pgAdmin III database management system to back up and restore your database http://get.enterprisedb.com/docs/Tutorial_All_PP_pgAdmin_Backup_Restore.pdf.

Plain text backup files generated from the backup with pgAdmin III cannot be restored in pgAdmin III.

A batch script backup.bat is provided on the Image Studio 21 CFR Part 11 installation CD to assist with automated backups. This script calls pg_dump.exe to create a plain text backup.

Copy the batch script from the installation CD to the server, and modify the script as necessary for use in your backup procedure.

Additional backup and restore information can be found on the PostgreSQL wiki https://wiki.postgresql.org/wiki/Automated_Backup_on_Windows.

Use the following command (as the PostgreSQL administrative user) to restore a plain text backup from pgAdmin III (where the backup file is MyBackup_10_29_2015.backup).

"C:\Program Files\Postgresql\9.3\bin\psql.exe" -d "licor_image_studio" -f "MyBackup_10_29_2015.backup" –U “<user name>"