Концепт
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.
You can relocate your TimescaleDB database by restoring its backup on another computer.
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