记一次 TimescaleDB 的数据备份与恢复

TimescaleDB 相关

• 启动一次服务器，确保已经创建了 senssion 表 和 event 表

• 连接数据库

  psql postgres://postgres:xxx@localhost:5432/xxx

TimescaleDB 数据备份与恢复

• 导出CSV

  set client_encoding=UTF8;
  \COPY (SELECT * FROM senssion) TO 'timescale-senssion.csv' DELIMITER ',' CSV HEADER ENCODING 'UTF8';
  \COPY (SELECT * FROM event) TO 'timescale-event.csv' DELIMITER ',' CSV HEADER ENCODING 'UTF8';

• 从CSV导入数据

  set client_encoding=UTF8;
  \COPY senssion FROM 'timescale-senssion.csv' DELIMITER ',' CSV HEADER ENCODING 'UTF8';
  \COPY event FROM 'timescale-event.csv' DELIMITER ',' CSV HEADER ENCODING 'UTF8';