How to Move Database Table with Screenshots to New Hard Disk

Recording Service performance may vary depending on the hardware configuration. If you intend to use more than 20 Recorder instances, store PostgreSQL databases partially or fully on the SSD for better performance.

Important. Only the database table with screenshots is allowed to be moved to a new hard disk.

To do it, when the Recording Service installation or upgrade is complete, perform the following steps:

  1. Create a folder on HDD, e.g., D:\PostgresData
  2. Provide full access to this folder to account is used to run PostgreSQL service.
    The default account is: NT AUTHORITY\NetworkService
  3. Perform as superuser the following actions on your PostgreSQL instance:
    1. Register a new tablespace to define an alternative location on the file system where the data files containing database tables and indexes will reside.
      To do this, run the command:
      CREATE TABLESPACE tablespace_name LOCATION 'directory';
      Example:
      CREATE TABLESPACE slow_large_disk LOCATION 'D:\PostgresData';

      Note. Skip this step if you register a new tablespace for the Recording Service 5.3 screenshots.
    2. Change the screenshot table's tablespace to the specified tablespace and move the data file(s) associated with the table to the new tablespace.

      ALTER TABLE "Blob" SET TABLESPACE new_tablespace;
      Example:
      ALTER TABLE "Blob" SET TABLESPACE slow_large_disk;
      Note. Even if you moved the Recording Service 5.3 Screenshot table, you need to repeat this step for the Recording Service 6.0 Blob table.
      Do not move the other tables' data files.

9/5/2024 4:23:54 PM

Usage of Cookies. In order to optimize the website functionality and improve your online experience ABBYY uses cookies. You agree to the usage of cookies when you continue using this site. Further details can be found in our Privacy Notice.