Pojęcie
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.
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. Więcej informacji zawiera 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. Więcej informacji zawiera Enabling a TimescaleDB Connection .
External Log Storage
Backup and Restore Overview
Enabling a TimescaleDB Connection
Disabling a TimescaleDB Connection