earth_america
user_standard 登录
action_search_stroke
earth_america
登录以评价并提供反馈 1 2 3 4 5 登录以评价
0
概念

概念


产品: AS-B, Edge Server, Enterprise Central, Enterprise Server, AS-P, Project Configuration Tool
功能: 工程, 趋势
产品版本: 2023
2022/12/17

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.

通知

数据丢失

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

不遵照这些说明可导致数据丢失。

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. 有关更多信息,请参阅 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. 有关更多信息,请参阅 Enabling a TimescaleDB Connection .

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