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, Edge Server, Enterprise Central, Enterprise Server, AS-P, Virtual Project Servers
Functionalities: Engineering, Trends
Product version: 2023
12/17/2022

External Log Storage Backup and Restore

The External Log Storage feature uses an external database software. Either a combination of TimescaleDB and PostgreSQL software, or Microsoft SQL Server. 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 the database software External Log Storage is configured with. See the TimescaleDB documentation or the Microsoft SQL Server documentation for instructions.

TimescaleDB 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 Overview
  • Backup and Restore Overview
  • Enabling a TimescaleDB Connection
  • Disabling a TimescaleDB Connection