Sop: Migration from native postgresql to timescaledb

[binary111]

I have been using the Native Postgresql till now and want to migrate to timescaledb.

I have performed following steps and require help to understand if it's the right process or there's any better alternative?

1. Migrate the db docker image to use the timescaledb.
2. Install the timescaledb extension.
3. Update the schema_type of table admin.storage_schema_type to timescaledb from postgresql.
4. Rename 494984 metrics like (table_stats to table_stats_old)
5. Remove and add the metrics from the preset so that it's automatically created.
6. Migrate the older data (last x days). Eg. table_stats_old to table_stats

[pashagolub]

Yup, sounds like a good plan! I hope it's worked as a charm!

How long is a retention period in your environment? Maybe it's worth just to start over with a clean TS database and let old data "rot" in the postgres.