timescale/docs.timescale.com-content

[Bug/Typo] typo in upgrade to version 2.0 doc

Opened this issue · 0 comments

Description
\COPY timescaledb_information.continuous_aggregates_stats TO ‘continuous_aggregates_stats.csv’ csv header

should actually be

\COPY timescaledb_information.continuous_aggregate_stats TO ‘continuous_aggregate_stats.csv’ csv header

(aggregate without an s at the end).

Additionally at least my psql says

can not copy from view ...
try variant COPY (SELECT ...) TO

Maybe you should adapt it to this.

Location

update-timescaledb/update-tsdb-2.md#step-1-verify-timescaledb-1x-policy-settings-optional