earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
Concept

Concept


Products: AS-B, Enterprise Central, Enterprise Server, AS-P, Project Configuration Tool
Functionalities: Engineering, Trends
Product version: 3.0, 3.1, 3.2, 3.3, 2022
10/27/2022

External Log Storage Backup and Restore

The External Log Storage feature uses an external database administered by a combination of TimescaleDB and PostgreSQL software. The EcoStruxure Building Operation backup and restore feature cannot be used to back up and restore the External Log Storage data. Instead you use the backup and restore function of TimescaleDB. See the TimescaleDB documentation for instructions.

Database Relocation to Another Computer

You can relocate your TimescaleDB database by restoring its backup on another computer.

Notice

Loss of data

Disable event and trend storage in the EcoStruxure Building Operation software at the beginning of the process and enable it at the end.

Failure to follow these instructions can result in loss of data.

In order to relocate Timescale DB database, you need to:

  • Make sure that the version of TimescaleDB installed on the source and target computer is the same.

  • Disable TimescaleDB connection for all servers connected to the database being relocated. For more information, see Disabling a TimescaleDB Connection .

  • Open an external database administrator tool, e.g.pgAdmin.

  • Execute the command: SELECT timescaledb_pre_restore();

  • Execute the restore as indicated in the PostgreSQL database documentation.

  • Execute the command: SELECT timescaledb_post_restore();

  • Enable event and trend storage in TimescaleDB for all servers that you want to connect to the relocated database. For more information, see Enabling a TimescaleDB Connection .

  • External Log Storage
  • Backup and Restore Overview
  • Enabling a TimescaleDB Connection
  • Disabling a TimescaleDB Connection